In this project, I will attempt to predict whether, for any given parcel in Detroit with a building on it, whether a building on that parcel will be be targetted for demoltion. Potential predictors, downloaded from https://data.detroitmi.gov/, include citations relatated to the building, crime, and complaints concerning the building related to blight. The probject is currently at the data cleaning stage, and I may add some other data to the project. So far, I am using about 3GB of data.
library(tidyverse)
library(sf)
library(ggmap)
library(lwgeom)
#recorded violations associated with blight (e.g. unkempt properties)
blight_violations <- read_csv("./data/Blight_Violations_3_19_2018.csv",
guess_max = 10^6)
Parsed with column specification:
cols(
.default = col_character(),
`Ticket ID` = col_integer(),
`Violator ID` = col_integer(),
`Violation Street Number` = col_integer(),
`Hearing Time` = col_time(format = ""),
`Violation Latitude` = col_double(),
`Violation Longitude` = col_double()
)
See spec(...) for full column specifications.
| | 0%
| | 0%
| | 0%
| | 0%
| | 0% 1 MB
| | 0% 1 MB
| | 0% 1 MB
| | 0% 1 MB
| | 0% 1 MB
| | 0% 1 MB
| | 0% 1 MB
| | 1% 1 MB
|= | 1% 1 MB
|= | 1% 2 MB
|= | 1% 2 MB
|= | 1% 2 MB
|= | 1% 2 MB
|= | 1% 2 MB
|= | 1% 2 MB
|= | 1% 2 MB
|= | 1% 2 MB
|= | 1% 2 MB
|= | 1% 3 MB
|= | 1% 3 MB
|= | 1% 3 MB
|= | 1% 3 MB
|= | 2% 3 MB
|= | 2% 3 MB
|= | 2% 3 MB
|== | 2% 3 MB
|== | 2% 3 MB
|== | 2% 4 MB
|== | 2% 4 MB
|== | 2% 4 MB
|== | 2% 4 MB
|== | 2% 4 MB
|== | 2% 4 MB
|== | 2% 4 MB
|== | 2% 4 MB
|== | 2% 4 MB
|== | 2% 5 MB
|== | 3% 5 MB
|== | 3% 5 MB
|== | 3% 5 MB
|== | 3% 5 MB
|=== | 3% 5 MB
|=== | 3% 5 MB
|=== | 3% 5 MB
|=== | 3% 5 MB
|=== | 3% 6 MB
|=== | 3% 6 MB
|=== | 3% 6 MB
|=== | 3% 6 MB
|=== | 3% 6 MB
|=== | 3% 6 MB
|=== | 3% 6 MB
|=== | 4% 6 MB
|=== | 4% 6 MB
|=== | 4% 7 MB
|=== | 4% 7 MB
|=== | 4% 7 MB
|=== | 4% 7 MB
|==== | 4% 7 MB
|==== | 4% 7 MB
|==== | 4% 7 MB
|==== | 4% 7 MB
|==== | 4% 7 MB
|==== | 4% 8 MB
|==== | 4% 8 MB
|==== | 4% 8 MB
|==== | 4% 8 MB
|==== | 5% 8 MB
|==== | 5% 8 MB
|==== | 5% 8 MB
|==== | 5% 8 MB
|==== | 5% 8 MB
|==== | 5% 9 MB
|==== | 5% 9 MB
|==== | 5% 9 MB
|===== | 5% 9 MB
|===== | 5% 9 MB
|===== | 5% 9 MB
|===== | 5% 9 MB
|===== | 5% 9 MB
|===== | 5% 9 MB
|===== | 5% 10 MB
|===== | 6% 10 MB
|===== | 6% 10 MB
|===== | 6% 10 MB
|===== | 6% 10 MB
|===== | 6% 10 MB
|===== | 6% 10 MB
|===== | 6% 10 MB
|===== | 6% 11 MB
|===== | 6% 11 MB
|====== | 6% 11 MB
|====== | 6% 11 MB
|====== | 6% 11 MB
|====== | 6% 11 MB
|====== | 6% 11 MB
|====== | 6% 11 MB
|====== | 6% 11 MB
|====== | 7% 12 MB
|====== | 7% 12 MB
|====== | 7% 12 MB
|====== | 7% 12 MB
|====== | 7% 12 MB
|====== | 7% 12 MB
|====== | 7% 12 MB
|====== | 7% 12 MB
|====== | 7% 12 MB
|====== | 7% 13 MB
|======= | 7% 13 MB
|======= | 7% 13 MB
|======= | 7% 13 MB
|======= | 7% 13 MB
|======= | 7% 13 MB
|======= | 8% 13 MB
|======= | 8% 13 MB
|======= | 8% 13 MB
|======= | 8% 14 MB
|======= | 8% 14 MB
|======= | 8% 14 MB
|======= | 8% 14 MB
|======= | 8% 14 MB
|======= | 8% 14 MB
|======= | 8% 14 MB
|======= | 8% 14 MB
|======== | 8% 14 MB
|======== | 8% 15 MB
|======== | 8% 15 MB
|======== | 9% 15 MB
|======== | 9% 15 MB
|======== | 9% 15 MB
|======== | 9% 15 MB
|======== | 9% 15 MB
|======== | 9% 15 MB
|======== | 9% 16 MB
|======== | 9% 16 MB
|======== | 9% 16 MB
|======== | 9% 16 MB
|======== | 9% 16 MB
|======== | 9% 16 MB
|======== | 9% 16 MB
|========= | 9% 16 MB
|========= | 9% 16 MB
|========= | 10% 17 MB
|========= | 10% 17 MB
|========= | 10% 17 MB
|========= | 10% 17 MB
|========= | 10% 17 MB
|========= | 10% 17 MB
|========= | 10% 17 MB
|========= | 10% 17 MB
|========= | 10% 17 MB
|========= | 10% 18 MB
|========= | 10% 18 MB
|========= | 10% 18 MB
|========= | 10% 18 MB
|========= | 10% 18 MB
|========= | 10% 18 MB
|========== | 11% 18 MB
|========== | 11% 18 MB
|========== | 11% 18 MB
|========== | 11% 19 MB
|========== | 11% 19 MB
|========== | 11% 19 MB
|========== | 11% 19 MB
|========== | 11% 19 MB
|========== | 11% 19 MB
|========== | 11% 19 MB
|========== | 11% 19 MB
|========== | 11% 19 MB
|========== | 11% 20 MB
|========== | 11% 20 MB
|========== | 11% 20 MB
|========== | 12% 20 MB
|========== | 12% 20 MB
|=========== | 12% 20 MB
|=========== | 12% 20 MB
|=========== | 12% 20 MB
|=========== | 12% 20 MB
|=========== | 12% 21 MB
|=========== | 12% 21 MB
|=========== | 12% 21 MB
|=========== | 12% 21 MB
|=========== | 12% 21 MB
|=========== | 12% 21 MB
|=========== | 12% 21 MB
|=========== | 12% 21 MB
|=========== | 12% 21 MB
|=========== | 12% 22 MB
|=========== | 13% 22 MB
|=========== | 13% 22 MB
|=========== | 13% 22 MB
|============ | 13% 22 MB
|============ | 13% 22 MB
|============ | 13% 22 MB
|============ | 13% 22 MB
|============ | 13% 22 MB
|============ | 13% 23 MB
|============ | 13% 23 MB
|============ | 13% 23 MB
|============ | 13% 23 MB
|============ | 13% 23 MB
|============ | 13% 23 MB
|============ | 13% 23 MB
|============ | 14% 23 MB
|============ | 14% 23 MB
|============ | 14% 24 MB
|============ | 14% 24 MB
|============ | 14% 24 MB
|============= | 14% 24 MB
|============= | 14% 24 MB
|============= | 14% 24 MB
|============= | 14% 24 MB
|============= | 14% 24 MB
|============= | 14% 24 MB
|============= | 14% 25 MB
|============= | 14% 25 MB
|============= | 14% 25 MB
|============= | 14% 25 MB
|============= | 14% 25 MB
|============= | 15% 25 MB
|============= | 15% 25 MB
|============= | 15% 25 MB
|============= | 15% 25 MB
|============= | 15% 26 MB
|============== | 15% 26 MB
|============== | 15% 26 MB
|============== | 15% 26 MB
|============== | 15% 26 MB
|============== | 15% 26 MB
|============== | 15% 26 MB
|============== | 15% 26 MB
|============== | 15% 26 MB
|============== | 15% 27 MB
|============== | 15% 27 MB
|============== | 16% 27 MB
|============== | 16% 27 MB
|============== | 16% 27 MB
|============== | 16% 27 MB
|============== | 16% 27 MB
|============== | 16% 27 MB
|============== | 16% 27 MB
|=============== | 16% 28 MB
|=============== | 16% 28 MB
|=============== | 16% 28 MB
|=============== | 16% 28 MB
|=============== | 16% 28 MB
|=============== | 16% 28 MB
|=============== | 16% 28 MB
|=============== | 16% 28 MB
|=============== | 17% 28 MB
|=============== | 17% 29 MB
|=============== | 17% 29 MB
|=============== | 17% 29 MB
|=============== | 17% 29 MB
|=============== | 17% 29 MB
|=============== | 17% 29 MB
|=============== | 17% 29 MB
|=============== | 17% 29 MB
|================ | 17% 29 MB
|================ | 17% 30 MB
|================ | 17% 30 MB
|================ | 17% 30 MB
|================ | 17% 30 MB
|================ | 17% 30 MB
|================ | 17% 30 MB
|================ | 18% 30 MB
|================ | 18% 30 MB
|================ | 18% 30 MB
|================ | 18% 31 MB
|================ | 18% 31 MB
|================ | 18% 31 MB
|================ | 18% 31 MB
|================ | 18% 31 MB
|================ | 18% 31 MB
|================ | 18% 31 MB
|================= | 18% 31 MB
|================= | 18% 31 MB
|================= | 18% 32 MB
|================= | 18% 32 MB
|================= | 18% 32 MB
|================= | 19% 32 MB
|================= | 19% 32 MB
|================= | 19% 32 MB
|================= | 19% 32 MB
|================= | 19% 32 MB
|================= | 19% 32 MB
|================= | 19% 33 MB
|================= | 19% 33 MB
|================= | 19% 33 MB
|================= | 19% 33 MB
|================= | 19% 33 MB
|================= | 19% 33 MB
|================== | 19% 33 MB
|================== | 19% 33 MB
|================== | 19% 33 MB
|================== | 19% 33 MB
|================== | 20% 34 MB
|================== | 20% 34 MB
|================== | 20% 34 MB
|================== | 20% 34 MB
|================== | 20% 34 MB
|================== | 20% 34 MB
|================== | 20% 34 MB
|================== | 20% 34 MB
|================== | 20% 34 MB
|================== | 20% 35 MB
|================== | 20% 35 MB
|================== | 20% 35 MB
|================== | 20% 35 MB
|=================== | 20% 35 MB
|=================== | 20% 35 MB
|=================== | 21% 35 MB
|=================== | 21% 35 MB
|=================== | 21% 35 MB
|=================== | 21% 36 MB
|=================== | 21% 36 MB
|=================== | 21% 36 MB
|=================== | 21% 36 MB
|=================== | 21% 36 MB
|=================== | 21% 36 MB
|=================== | 21% 36 MB
|=================== | 21% 36 MB
|=================== | 21% 36 MB
|=================== | 21% 37 MB
|=================== | 21% 37 MB
|=================== | 21% 37 MB
|==================== | 22% 37 MB
|==================== | 22% 37 MB
|==================== | 22% 37 MB
|==================== | 22% 37 MB
|==================== | 22% 37 MB
|==================== | 22% 37 MB
|==================== | 22% 38 MB
|==================== | 22% 38 MB
|==================== | 22% 38 MB
|==================== | 22% 38 MB
|==================== | 22% 38 MB
|==================== | 22% 38 MB
|==================== | 22% 38 MB
|==================== | 22% 38 MB
|==================== | 22% 38 MB
|==================== | 22% 39 MB
|==================== | 23% 39 MB
|===================== | 23% 39 MB
|===================== | 23% 39 MB
|===================== | 23% 39 MB
|===================== | 23% 39 MB
|===================== | 23% 39 MB
|===================== | 23% 39 MB
|===================== | 23% 39 MB
|===================== | 23% 40 MB
|===================== | 23% 40 MB
|===================== | 23% 40 MB
|===================== | 23% 40 MB
|===================== | 23% 40 MB
|===================== | 23% 40 MB
|===================== | 23% 40 MB
|===================== | 24% 40 MB
|===================== | 24% 40 MB
|===================== | 24% 41 MB
|====================== | 24% 41 MB
|====================== | 24% 41 MB
|====================== | 24% 41 MB
|====================== | 24% 41 MB
|====================== | 24% 41 MB
|====================== | 24% 41 MB
|====================== | 24% 41 MB
|====================== | 24% 41 MB
|====================== | 24% 42 MB
|====================== | 24% 42 MB
|====================== | 24% 42 MB
|====================== | 24% 42 MB
|====================== | 24% 42 MB
|====================== | 25% 42 MB
|====================== | 25% 42 MB
|====================== | 25% 42 MB
|====================== | 25% 42 MB
|======================= | 25% 43 MB
|======================= | 25% 43 MB
|======================= | 25% 43 MB
|======================= | 25% 43 MB
|======================= | 25% 43 MB
|======================= | 25% 43 MB
|======================= | 25% 43 MB
|======================= | 25% 43 MB
|======================= | 25% 43 MB
|======================= | 25% 44 MB
|======================= | 25% 44 MB
|======================= | 26% 44 MB
|======================= | 26% 44 MB
|======================= | 26% 44 MB
|======================= | 26% 44 MB
|======================= | 26% 44 MB
|======================= | 26% 44 MB
|======================== | 26% 44 MB
|======================== | 26% 45 MB
|======================== | 26% 45 MB
|======================== | 26% 45 MB
|======================== | 26% 45 MB
|======================== | 26% 45 MB
|======================== | 26% 45 MB
|======================== | 26% 45 MB
|======================== | 26% 45 MB
|======================== | 26% 45 MB
|======================== | 27% 46 MB
|======================== | 27% 46 MB
|======================== | 27% 46 MB
|======================== | 27% 46 MB
|======================== | 27% 46 MB
|======================== | 27% 46 MB
|======================== | 27% 46 MB
|========================= | 27% 46 MB
|========================= | 27% 46 MB
|========================= | 27% 47 MB
|========================= | 27% 47 MB
|========================= | 27% 47 MB
|========================= | 27% 47 MB
|========================= | 27% 47 MB
|========================= | 27% 47 MB
|========================= | 28% 47 MB
|========================= | 28% 47 MB
|========================= | 28% 47 MB
|========================= | 28% 48 MB
|========================= | 28% 48 MB
|========================= | 28% 48 MB
|========================= | 28% 48 MB
|========================= | 28% 48 MB
|========================== | 28% 48 MB
|========================== | 28% 48 MB
|========================== | 28% 48 MB
|========================== | 28% 48 MB
|========================== | 28% 49 MB
|========================== | 28% 49 MB
|========================== | 28% 49 MB
|========================== | 29% 49 MB
|========================== | 29% 49 MB
|========================== | 29% 49 MB
|========================== | 29% 49 MB
|========================== | 29% 49 MB
|========================== | 29% 49 MB
|========================== | 29% 50 MB
|========================== | 29% 50 MB
|========================== | 29% 50 MB
|========================== | 29% 50 MB
|=========================== | 29% 50 MB
|=========================== | 29% 50 MB
|=========================== | 29% 50 MB
|=========================== | 29% 50 MB
|=========================== | 29% 50 MB
|=========================== | 30% 51 MB
|=========================== | 30% 51 MB
|=========================== | 30% 51 MB
|=========================== | 30% 51 MB
|=========================== | 30% 51 MB
|=========================== | 30% 51 MB
|=========================== | 30% 51 MB
|=========================== | 30% 51 MB
|=========================== | 30% 51 MB
|=========================== | 30% 52 MB
|=========================== | 30% 52 MB
|=========================== | 30% 52 MB
|============================ | 30% 52 MB
|============================ | 30% 52 MB
|============================ | 30% 52 MB
|============================ | 31% 52 MB
|============================ | 31% 52 MB
|============================ | 31% 52 MB
|============================ | 31% 53 MB
|============================ | 31% 53 MB
|============================ | 31% 53 MB
|============================ | 31% 53 MB
|============================ | 31% 53 MB
|============================ | 31% 53 MB
|============================ | 31% 53 MB
|============================ | 31% 53 MB
|============================ | 31% 53 MB
|============================ | 31% 54 MB
|============================= | 31% 54 MB
|============================= | 31% 54 MB
|============================= | 32% 54 MB
|============================= | 32% 54 MB
|============================= | 32% 54 MB
|============================= | 32% 54 MB
|============================= | 32% 54 MB
|============================= | 32% 55 MB
|============================= | 32% 55 MB
|============================= | 32% 55 MB
|============================= | 32% 55 MB
|============================= | 32% 55 MB
|============================= | 32% 55 MB
|============================= | 32% 55 MB
|============================= | 32% 55 MB
|============================= | 32% 55 MB
|============================= | 32% 56 MB
|============================== | 33% 56 MB
|============================== | 33% 56 MB
|============================== | 33% 56 MB
|============================== | 33% 56 MB
|============================== | 33% 56 MB
|============================== | 33% 56 MB
|============================== | 33% 56 MB
|============================== | 33% 56 MB
|============================== | 33% 57 MB
|============================== | 33% 57 MB
|============================== | 33% 57 MB
|============================== | 33% 57 MB
|============================== | 33% 57 MB
|============================== | 33% 57 MB
|============================== | 33% 57 MB
|============================== | 34% 57 MB
|=============================== | 34% 57 MB
|=============================== | 34% 58 MB
|=============================== | 34% 58 MB
|=============================== | 34% 58 MB
|=============================== | 34% 58 MB
|=============================== | 34% 58 MB
|=============================== | 34% 58 MB
|=============================== | 34% 58 MB
|=============================== | 34% 58 MB
|=============================== | 34% 58 MB
|=============================== | 34% 59 MB
|=============================== | 34% 59 MB
|=============================== | 34% 59 MB
|=============================== | 34% 59 MB
|=============================== | 35% 59 MB
|=============================== | 35% 59 MB
|=============================== | 35% 59 MB
|================================ | 35% 59 MB
|================================ | 35% 59 MB
|================================ | 35% 60 MB
|================================ | 35% 60 MB
|================================ | 35% 60 MB
|================================ | 35% 60 MB
|================================ | 35% 60 MB
|================================ | 35% 60 MB
|================================ | 35% 60 MB
|================================ | 35% 60 MB
|================================ | 35% 60 MB
|================================ | 35% 61 MB
|================================ | 35% 61 MB
|================================ | 36% 61 MB
|================================ | 36% 61 MB
|================================ | 36% 61 MB
|================================ | 36% 61 MB
|================================= | 36% 61 MB
|================================= | 36% 61 MB
|================================= | 36% 61 MB
|================================= | 36% 62 MB
|================================= | 36% 62 MB
|================================= | 36% 62 MB
|================================= | 36% 62 MB
|================================= | 36% 62 MB
|================================= | 36% 62 MB
|================================= | 36% 62 MB
|================================= | 36% 62 MB
|================================= | 37% 62 MB
|================================= | 37% 63 MB
|================================= | 37% 63 MB
|================================= | 37% 63 MB
|================================= | 37% 63 MB
|================================== | 37% 63 MB
|================================== | 37% 63 MB
|================================== | 37% 63 MB
|================================== | 37% 63 MB
|================================== | 37% 63 MB
|================================== | 37% 64 MB
|================================== | 37% 64 MB
|================================== | 37% 64 MB
|================================== | 37% 64 MB
|================================== | 37% 64 MB
|================================== | 38% 64 MB
|================================== | 38% 64 MB
|================================== | 38% 64 MB
|================================== | 38% 64 MB
|================================== | 38% 65 MB
|================================== | 38% 65 MB
|================================== | 38% 65 MB
|=================================== | 38% 65 MB
|=================================== | 38% 65 MB
|=================================== | 38% 65 MB
|=================================== | 38% 65 MB
|=================================== | 38% 65 MB
|=================================== | 38% 66 MB
|=================================== | 38% 66 MB
|=================================== | 38% 66 MB
|=================================== | 39% 66 MB
|=================================== | 39% 66 MB
|=================================== | 39% 66 MB
|=================================== | 39% 66 MB
|=================================== | 39% 66 MB
|=================================== | 39% 66 MB
|=================================== | 39% 67 MB
|=================================== | 39% 67 MB
|=================================== | 39% 67 MB
|==================================== | 39% 67 MB
|==================================== | 39% 67 MB
|==================================== | 39% 67 MB
|==================================== | 39% 67 MB
|==================================== | 39% 67 MB
|==================================== | 39% 67 MB
|==================================== | 40% 68 MB
|==================================== | 40% 68 MB
|==================================== | 40% 68 MB
|==================================== | 40% 68 MB
|==================================== | 40% 68 MB
|==================================== | 40% 68 MB
|==================================== | 40% 68 MB
|==================================== | 40% 68 MB
|==================================== | 40% 68 MB
|==================================== | 40% 69 MB
|===================================== | 40% 69 MB
|===================================== | 40% 69 MB
|===================================== | 40% 69 MB
|===================================== | 40% 69 MB
|===================================== | 40% 69 MB
|===================================== | 41% 69 MB
|===================================== | 41% 69 MB
|===================================== | 41% 69 MB
|===================================== | 41% 70 MB
|===================================== | 41% 70 MB
|===================================== | 41% 70 MB
|===================================== | 41% 70 MB
|===================================== | 41% 70 MB
|===================================== | 41% 70 MB
|===================================== | 41% 70 MB
|===================================== | 41% 70 MB
|===================================== | 41% 70 MB
|====================================== | 41% 71 MB
|====================================== | 41% 71 MB
|====================================== | 41% 71 MB
|====================================== | 41% 71 MB
|====================================== | 42% 71 MB
|====================================== | 42% 71 MB
|====================================== | 42% 71 MB
|====================================== | 42% 71 MB
|====================================== | 42% 71 MB
|====================================== | 42% 72 MB
|====================================== | 42% 72 MB
|====================================== | 42% 72 MB
|====================================== | 42% 72 MB
|====================================== | 42% 72 MB
|====================================== | 42% 72 MB
|====================================== | 42% 72 MB
|====================================== | 42% 72 MB
|======================================= | 42% 72 MB
|======================================= | 42% 73 MB
|======================================= | 43% 73 MB
|======================================= | 43% 73 MB
|======================================= | 43% 73 MB
|======================================= | 43% 73 MB
|======================================= | 43% 73 MB
|======================================= | 43% 73 MB
|======================================= | 43% 73 MB
|======================================= | 43% 73 MB
|======================================= | 43% 74 MB
|======================================= | 43% 74 MB
|======================================= | 43% 74 MB
|======================================= | 43% 74 MB
|======================================= | 43% 74 MB
|======================================= | 43% 74 MB
|======================================== | 43% 74 MB
|======================================== | 44% 74 MB
|======================================== | 44% 74 MB
|======================================== | 44% 75 MB
|======================================== | 44% 75 MB
|======================================== | 44% 75 MB
|======================================== | 44% 75 MB
|======================================== | 44% 75 MB
|======================================== | 44% 75 MB
|======================================== | 44% 75 MB
|======================================== | 44% 75 MB
|======================================== | 44% 75 MB
|======================================== | 44% 76 MB
|======================================== | 44% 76 MB
|======================================== | 44% 76 MB
|======================================== | 44% 76 MB
|======================================== | 45% 76 MB
|========================================= | 45% 76 MB
|========================================= | 45% 76 MB
|========================================= | 45% 76 MB
|========================================= | 45% 76 MB
|========================================= | 45% 77 MB
|========================================= | 45% 77 MB
|========================================= | 45% 77 MB
|========================================= | 45% 77 MB
|========================================= | 45% 77 MB
|========================================= | 45% 77 MB
|========================================= | 45% 77 MB
|========================================= | 45% 77 MB
|========================================= | 45% 77 MB
|========================================= | 45% 78 MB
|========================================= | 45% 78 MB
|========================================= | 46% 78 MB
|========================================= | 46% 78 MB
|========================================== | 46% 78 MB
|========================================== | 46% 78 MB
|========================================== | 46% 78 MB
|========================================== | 46% 78 MB
|========================================== | 46% 78 MB
|========================================== | 46% 79 MB
|========================================== | 46% 79 MB
|========================================== | 46% 79 MB
|========================================== | 46% 79 MB
|========================================== | 46% 79 MB
|========================================== | 46% 79 MB
|========================================== | 46% 79 MB
|========================================== | 46% 79 MB
|========================================== | 47% 80 MB
|========================================== | 47% 80 MB
|========================================== | 47% 80 MB
|=========================================== | 47% 80 MB
|=========================================== | 47% 80 MB
|=========================================== | 47% 80 MB
|=========================================== | 47% 80 MB
|=========================================== | 47% 80 MB
|=========================================== | 47% 80 MB
|=========================================== | 47% 81 MB
|=========================================== | 47% 81 MB
|=========================================== | 47% 81 MB
|=========================================== | 47% 81 MB
|=========================================== | 47% 81 MB
|=========================================== | 47% 81 MB
|=========================================== | 48% 81 MB
|=========================================== | 48% 81 MB
|=========================================== | 48% 81 MB
|=========================================== | 48% 82 MB
|=========================================== | 48% 82 MB
|============================================ | 48% 82 MB
|============================================ | 48% 82 MB
|============================================ | 48% 82 MB
|============================================ | 48% 82 MB
|============================================ | 48% 82 MB
|============================================ | 48% 82 MB
|============================================ | 48% 82 MB
|============================================ | 48% 83 MB
|============================================ | 48% 83 MB
|============================================ | 48% 83 MB
|============================================ | 49% 83 MB
|============================================ | 49% 83 MB
|============================================ | 49% 83 MB
|============================================ | 49% 83 MB
|============================================ | 49% 83 MB
|============================================ | 49% 83 MB
|============================================ | 49% 84 MB
|============================================= | 49% 84 MB
|============================================= | 49% 84 MB
|============================================= | 49% 84 MB
|============================================= | 49% 84 MB
|============================================= | 49% 84 MB
|============================================= | 49% 84 MB
|============================================= | 49% 84 MB
|============================================= | 49% 84 MB
|============================================= | 50% 85 MB
|============================================= | 50% 85 MB
|============================================= | 50% 85 MB
|============================================= | 50% 85 MB
|============================================= | 50% 85 MB
|============================================= | 50% 85 MB
|============================================= | 50% 85 MB
|============================================= | 50% 85 MB
|============================================== | 50% 85 MB
|============================================== | 50% 86 MB
|============================================== | 50% 86 MB
|============================================== | 50% 86 MB
|============================================== | 50% 86 MB
|============================================== | 50% 86 MB
|============================================== | 50% 86 MB
|============================================== | 51% 86 MB
|============================================== | 51% 86 MB
|============================================== | 51% 87 MB
|============================================== | 51% 87 MB
|============================================== | 51% 87 MB
|============================================== | 51% 87 MB
|============================================== | 51% 87 MB
|============================================== | 51% 87 MB
|============================================== | 51% 87 MB
|=============================================== | 51% 87 MB
|=============================================== | 51% 87 MB
|=============================================== | 51% 88 MB
|=============================================== | 51% 88 MB
|=============================================== | 51% 88 MB
|=============================================== | 51% 88 MB
|=============================================== | 52% 88 MB
|=============================================== | 52% 88 MB
|=============================================== | 52% 88 MB
|=============================================== | 52% 88 MB
|=============================================== | 52% 88 MB
|=============================================== | 52% 89 MB
|=============================================== | 52% 89 MB
|=============================================== | 52% 89 MB
|=============================================== | 52% 89 MB
|=============================================== | 52% 89 MB
|=============================================== | 52% 89 MB
|================================================ | 52% 89 MB
|================================================ | 52% 89 MB
|================================================ | 52% 89 MB
|================================================ | 52% 90 MB
|================================================ | 53% 90 MB
|================================================ | 53% 90 MB
|================================================ | 53% 90 MB
|================================================ | 53% 90 MB
|================================================ | 53% 90 MB
|================================================ | 53% 90 MB
|================================================ | 53% 90 MB
|================================================ | 53% 91 MB
|================================================ | 53% 91 MB
|================================================ | 53% 91 MB
|================================================ | 53% 91 MB
|================================================ | 53% 91 MB
|================================================= | 53% 91 MB
|================================================= | 53% 91 MB
|================================================= | 53% 91 MB
|================================================= | 54% 91 MB
|================================================= | 54% 92 MB
|================================================= | 54% 92 MB
|================================================= | 54% 92 MB
|================================================= | 54% 92 MB
|================================================= | 54% 92 MB
|================================================= | 54% 92 MB
|================================================= | 54% 92 MB
|================================================= | 54% 92 MB
|================================================= | 54% 92 MB
|================================================= | 54% 93 MB
|================================================= | 54% 93 MB
|================================================= | 54% 93 MB
|================================================= | 54% 93 MB
|================================================== | 55% 93 MB
|================================================== | 55% 93 MB
|================================================== | 55% 93 MB
|================================================== | 55% 93 MB
|================================================== | 55% 93 MB
|================================================== | 55% 94 MB
|================================================== | 55% 94 MB
|================================================== | 55% 94 MB
|================================================== | 55% 94 MB
|================================================== | 55% 94 MB
|================================================== | 55% 94 MB
|================================================== | 55% 94 MB
|================================================== | 55% 94 MB
|================================================== | 55% 94 MB
|================================================== | 55% 95 MB
|================================================== | 56% 95 MB
|=================================================== | 56% 95 MB
|=================================================== | 56% 95 MB
|=================================================== | 56% 95 MB
|=================================================== | 56% 95 MB
|=================================================== | 56% 95 MB
|=================================================== | 56% 95 MB
|=================================================== | 56% 96 MB
|=================================================== | 56% 96 MB
|=================================================== | 56% 96 MB
|=================================================== | 56% 96 MB
|=================================================== | 56% 96 MB
|=================================================== | 56% 96 MB
|=================================================== | 56% 96 MB
|=================================================== | 56% 96 MB
|=================================================== | 57% 96 MB
|=================================================== | 57% 97 MB
|==================================================== | 57% 97 MB
|==================================================== | 57% 97 MB
|==================================================== | 57% 97 MB
|==================================================== | 57% 97 MB
|==================================================== | 57% 97 MB
|==================================================== | 57% 97 MB
|==================================================== | 57% 97 MB
|==================================================== | 57% 97 MB
|==================================================== | 57% 98 MB
|==================================================== | 57% 98 MB
|==================================================== | 57% 98 MB
|==================================================== | 57% 98 MB
|==================================================== | 57% 98 MB
|==================================================== | 58% 98 MB
|==================================================== | 58% 98 MB
|==================================================== | 58% 98 MB
|==================================================== | 58% 98 MB
|===================================================== | 58% 99 MB
|===================================================== | 58% 99 MB
|===================================================== | 58% 99 MB
|===================================================== | 58% 99 MB
|===================================================== | 58% 99 MB
|===================================================== | 58% 99 MB
|===================================================== | 58% 99 MB
|===================================================== | 58% 99 MB
|===================================================== | 58% 100 MB
|===================================================== | 58% 100 MB
|===================================================== | 58% 100 MB
|===================================================== | 59% 100 MB
|===================================================== | 59% 100 MB
|===================================================== | 59% 100 MB
|===================================================== | 59% 100 MB
|===================================================== | 59% 100 MB
|====================================================== | 59% 100 MB
|====================================================== | 59% 101 MB
|====================================================== | 59% 101 MB
|====================================================== | 59% 101 MB
|====================================================== | 59% 101 MB
|====================================================== | 59% 101 MB
|====================================================== | 59% 101 MB
|====================================================== | 59% 101 MB
|====================================================== | 59% 101 MB
|====================================================== | 59% 101 MB
|====================================================== | 60% 102 MB
|====================================================== | 60% 102 MB
|====================================================== | 60% 102 MB
|====================================================== | 60% 102 MB
|====================================================== | 60% 102 MB
|====================================================== | 60% 102 MB
|====================================================== | 60% 102 MB
|======================================================= | 60% 102 MB
|======================================================= | 60% 102 MB
|======================================================= | 60% 103 MB
|======================================================= | 60% 103 MB
|======================================================= | 60% 103 MB
|======================================================= | 60% 103 MB
|======================================================= | 60% 103 MB
|======================================================= | 60% 103 MB
|======================================================= | 61% 103 MB
|======================================================= | 61% 103 MB
|======================================================= | 61% 103 MB
|======================================================= | 61% 104 MB
|======================================================= | 61% 104 MB
|======================================================= | 61% 104 MB
|======================================================= | 61% 104 MB
|======================================================= | 61% 104 MB
|======================================================== | 61% 104 MB
|======================================================== | 61% 104 MB
|======================================================== | 61% 104 MB
|======================================================== | 61% 105 MB
|======================================================== | 61% 105 MB
|======================================================== | 61% 105 MB
|======================================================== | 61% 105 MB
|======================================================== | 62% 105 MB
|======================================================== | 62% 105 MB
|======================================================== | 62% 105 MB
|======================================================== | 62% 105 MB
|======================================================== | 62% 105 MB
|======================================================== | 62% 106 MB
|======================================================== | 62% 106 MB
|======================================================== | 62% 106 MB
|======================================================== | 62% 106 MB
|========================================================= | 62% 106 MB
|========================================================= | 62% 106 MB
|========================================================= | 62% 106 MB
|========================================================= | 62% 106 MB
|========================================================= | 62% 106 MB
|========================================================= | 62% 107 MB
|========================================================= | 63% 107 MB
|========================================================= | 63% 107 MB
|========================================================= | 63% 107 MB
|========================================================= | 63% 107 MB
|========================================================= | 63% 107 MB
|========================================================= | 63% 107 MB
|========================================================= | 63% 107 MB
|========================================================= | 63% 108 MB
|========================================================= | 63% 108 MB
|========================================================= | 63% 108 MB
|========================================================= | 63% 108 MB
|========================================================== | 63% 108 MB
|========================================================== | 63% 108 MB
|========================================================== | 63% 108 MB
|========================================================== | 63% 108 MB
|========================================================== | 64% 108 MB
|========================================================== | 64% 109 MB
|========================================================== | 64% 109 MB
|========================================================== | 64% 109 MB
|========================================================== | 64% 109 MB
|========================================================== | 64% 109 MB
|========================================================== | 64% 109 MB
|========================================================== | 64% 109 MB
|========================================================== | 64% 109 MB
|========================================================== | 64% 109 MB
|========================================================== | 64% 110 MB
|========================================================== | 64% 110 MB
|=========================================================== | 64% 110 MB
|=========================================================== | 64% 110 MB
|=========================================================== | 65% 110 MB
|=========================================================== | 65% 110 MB
|=========================================================== | 65% 110 MB
|=========================================================== | 65% 110 MB
|=========================================================== | 65% 110 MB
|=========================================================== | 65% 111 MB
|=========================================================== | 65% 111 MB
|=========================================================== | 65% 111 MB
|=========================================================== | 65% 111 MB
|=========================================================== | 65% 111 MB
|=========================================================== | 65% 111 MB
|=========================================================== | 65% 111 MB
|=========================================================== | 65% 111 MB
|=========================================================== | 65% 112 MB
|============================================================ | 65% 112 MB
|============================================================ | 66% 112 MB
|============================================================ | 66% 112 MB
|============================================================ | 66% 112 MB
|============================================================ | 66% 112 MB
|============================================================ | 66% 112 MB
|============================================================ | 66% 112 MB
|============================================================ | 66% 112 MB
|============================================================ | 66% 113 MB
|============================================================ | 66% 113 MB
|============================================================ | 66% 113 MB
|============================================================ | 66% 113 MB
|============================================================ | 66% 113 MB
|============================================================ | 66% 113 MB
|============================================================ | 66% 113 MB
|============================================================ | 66% 113 MB
|============================================================= | 67% 113 MB
|============================================================= | 67% 114 MB
|============================================================= | 67% 114 MB
|============================================================= | 67% 114 MB
|============================================================= | 67% 114 MB
|============================================================= | 67% 114 MB
|============================================================= | 67% 114 MB
|============================================================= | 67% 114 MB
|============================================================= | 67% 114 MB
|============================================================= | 67% 114 MB
|============================================================= | 67% 115 MB
|============================================================= | 67% 115 MB
|============================================================= | 67% 115 MB
|============================================================= | 67% 115 MB
|============================================================= | 67% 115 MB
|============================================================= | 68% 115 MB
|============================================================= | 68% 115 MB
|============================================================== | 68% 115 MB
|============================================================== | 68% 116 MB
|============================================================== | 68% 116 MB
|============================================================== | 68% 116 MB
|============================================================== | 68% 116 MB
|============================================================== | 68% 116 MB
|============================================================== | 68% 116 MB
|============================================================== | 68% 116 MB
|============================================================== | 68% 116 MB
|============================================================== | 68% 116 MB
|============================================================== | 68% 117 MB
|============================================================== | 68% 117 MB
|============================================================== | 68% 117 MB
|============================================================== | 69% 117 MB
|============================================================== | 69% 117 MB
|============================================================== | 69% 117 MB
|=============================================================== | 69% 117 MB
|=============================================================== | 69% 117 MB
|=============================================================== | 69% 117 MB
|=============================================================== | 69% 118 MB
|=============================================================== | 69% 118 MB
|=============================================================== | 69% 118 MB
|=============================================================== | 69% 118 MB
|=============================================================== | 69% 118 MB
|=============================================================== | 69% 118 MB
|=============================================================== | 69% 118 MB
|=============================================================== | 69% 118 MB
|=============================================================== | 69% 119 MB
|=============================================================== | 70% 119 MB
|=============================================================== | 70% 119 MB
|=============================================================== | 70% 119 MB
|=============================================================== | 70% 119 MB
|================================================================ | 70% 119 MB
|================================================================ | 70% 119 MB
|================================================================ | 70% 119 MB
|================================================================ | 70% 119 MB
|================================================================ | 70% 120 MB
|================================================================ | 70% 120 MB
|================================================================ | 70% 120 MB
|================================================================ | 70% 120 MB
|================================================================ | 70% 120 MB
|================================================================ | 70% 120 MB
|================================================================ | 71% 120 MB
|================================================================ | 71% 120 MB
|================================================================ | 71% 120 MB
|================================================================ | 71% 121 MB
|================================================================ | 71% 121 MB
|================================================================ | 71% 121 MB
|================================================================ | 71% 121 MB
|================================================================= | 71% 121 MB
|================================================================= | 71% 121 MB
|================================================================= | 71% 121 MB
|================================================================= | 71% 121 MB
|================================================================= | 71% 121 MB
|================================================================= | 71% 122 MB
|================================================================= | 71% 122 MB
|================================================================= | 71% 122 MB
|================================================================= | 72% 122 MB
|================================================================= | 72% 122 MB
|================================================================= | 72% 122 MB
|================================================================= | 72% 122 MB
|================================================================= | 72% 122 MB
|================================================================= | 72% 123 MB
|================================================================= | 72% 123 MB
|================================================================= | 72% 123 MB
|================================================================== | 72% 123 MB
|================================================================== | 72% 123 MB
|================================================================== | 72% 123 MB
|================================================================== | 72% 123 MB
|================================================================== | 72% 123 MB
|================================================================== | 72% 123 MB
|================================================================== | 72% 124 MB
|================================================================== | 73% 124 MB
|================================================================== | 73% 124 MB
|================================================================== | 73% 124 MB
|================================================================== | 73% 124 MB
|================================================================== | 73% 124 MB
|================================================================== | 73% 124 MB
|================================================================== | 73% 124 MB
|================================================================== | 73% 124 MB
|================================================================== | 73% 125 MB
|=================================================================== | 73% 125 MB
|=================================================================== | 73% 125 MB
|=================================================================== | 73% 125 MB
|=================================================================== | 73% 125 MB
|=================================================================== | 73% 125 MB
|=================================================================== | 73% 125 MB
|=================================================================== | 74% 125 MB
|=================================================================== | 74% 126 MB
|=================================================================== | 74% 126 MB
|=================================================================== | 74% 126 MB
|=================================================================== | 74% 126 MB
|=================================================================== | 74% 126 MB
|=================================================================== | 74% 126 MB
|=================================================================== | 74% 126 MB
|=================================================================== | 74% 126 MB
|=================================================================== | 74% 126 MB
|=================================================================== | 74% 127 MB
|==================================================================== | 74% 127 MB
|==================================================================== | 74% 127 MB
|==================================================================== | 74% 127 MB
|==================================================================== | 74% 127 MB
|==================================================================== | 75% 127 MB
|==================================================================== | 75% 127 MB
|==================================================================== | 75% 127 MB
|==================================================================== | 75% 127 MB
|==================================================================== | 75% 128 MB
|==================================================================== | 75% 128 MB
|==================================================================== | 75% 128 MB
|==================================================================== | 75% 128 MB
|==================================================================== | 75% 128 MB
|==================================================================== | 75% 128 MB
|==================================================================== | 75% 128 MB
|==================================================================== | 75% 128 MB
|===================================================================== | 75% 128 MB
|===================================================================== | 75% 129 MB
|===================================================================== | 76% 129 MB
|===================================================================== | 76% 129 MB
|===================================================================== | 76% 129 MB
|===================================================================== | 76% 129 MB
|===================================================================== | 76% 129 MB
|===================================================================== | 76% 129 MB
|===================================================================== | 76% 129 MB
|===================================================================== | 76% 130 MB
|===================================================================== | 76% 130 MB
|===================================================================== | 76% 130 MB
|===================================================================== | 76% 130 MB
|===================================================================== | 76% 130 MB
|===================================================================== | 76% 130 MB
|===================================================================== | 76% 130 MB
|====================================================================== | 76% 130 MB
|====================================================================== | 77% 130 MB
|====================================================================== | 77% 131 MB
|====================================================================== | 77% 131 MB
|====================================================================== | 77% 131 MB
|====================================================================== | 77% 131 MB
|====================================================================== | 77% 131 MB
|====================================================================== | 77% 131 MB
|====================================================================== | 77% 131 MB
|====================================================================== | 77% 131 MB
|====================================================================== | 77% 131 MB
|====================================================================== | 77% 132 MB
|====================================================================== | 77% 132 MB
|====================================================================== | 77% 132 MB
|====================================================================== | 77% 132 MB
|====================================================================== | 77% 132 MB
|======================================================================= | 78% 132 MB
|======================================================================= | 78% 132 MB
|======================================================================= | 78% 132 MB
|======================================================================= | 78% 133 MB
|======================================================================= | 78% 133 MB
|======================================================================= | 78% 133 MB
|======================================================================= | 78% 133 MB
|======================================================================= | 78% 133 MB
|======================================================================= | 78% 133 MB
|======================================================================= | 78% 133 MB
|======================================================================= | 78% 133 MB
|======================================================================= | 78% 133 MB
|======================================================================= | 78% 134 MB
|======================================================================= | 78% 134 MB
|======================================================================= | 78% 134 MB
|======================================================================= | 79% 134 MB
|======================================================================= | 79% 134 MB
|======================================================================== | 79% 134 MB
|======================================================================== | 79% 134 MB
|======================================================================== | 79% 134 MB
|======================================================================== | 79% 134 MB
|======================================================================== | 79% 135 MB
|======================================================================== | 79% 135 MB
|======================================================================== | 79% 135 MB
|======================================================================== | 79% 135 MB
|======================================================================== | 79% 135 MB
|======================================================================== | 79% 135 MB
|======================================================================== | 79% 135 MB
|======================================================================== | 79% 135 MB
|======================================================================== | 79% 136 MB
|======================================================================== | 80% 136 MB
|======================================================================== | 80% 136 MB
|======================================================================== | 80% 136 MB
|========================================================================= | 80% 136 MB
|========================================================================= | 80% 136 MB
|========================================================================= | 80% 136 MB
|========================================================================= | 80% 136 MB
|========================================================================= | 80% 136 MB
|========================================================================= | 80% 137 MB
|========================================================================= | 80% 137 MB
|========================================================================= | 80% 137 MB
|========================================================================= | 80% 137 MB
|========================================================================= | 80% 137 MB
|========================================================================= | 80% 137 MB
|========================================================================= | 81% 137 MB
|========================================================================= | 81% 137 MB
|========================================================================= | 81% 137 MB
|========================================================================= | 81% 138 MB
|========================================================================= | 81% 138 MB
|========================================================================== | 81% 138 MB
|========================================================================== | 81% 138 MB
|========================================================================== | 81% 138 MB
|========================================================================== | 81% 138 MB
|========================================================================== | 81% 138 MB
|========================================================================== | 81% 138 MB
|========================================================================== | 81% 138 MB
|========================================================================== | 81% 139 MB
|========================================================================== | 81% 139 MB
|========================================================================== | 81% 139 MB
|========================================================================== | 82% 139 MB
|========================================================================== | 82% 139 MB
|========================================================================== | 82% 139 MB
|========================================================================== | 82% 139 MB
|========================================================================== | 82% 139 MB
|========================================================================== | 82% 140 MB
|=========================================================================== | 82% 140 MB
|=========================================================================== | 82% 140 MB
|=========================================================================== | 82% 140 MB
|=========================================================================== | 82% 140 MB
|=========================================================================== | 82% 140 MB
|=========================================================================== | 82% 140 MB
|=========================================================================== | 82% 140 MB
|=========================================================================== | 82% 140 MB
|=========================================================================== | 82% 141 MB
|=========================================================================== | 83% 141 MB
|=========================================================================== | 83% 141 MB
|=========================================================================== | 83% 141 MB
|=========================================================================== | 83% 141 MB
|=========================================================================== | 83% 141 MB
|=========================================================================== | 83% 141 MB
|=========================================================================== | 83% 141 MB
|=========================================================================== | 83% 141 MB
|============================================================================ | 83% 142 MB
|============================================================================ | 83% 142 MB
|============================================================================ | 83% 142 MB
|============================================================================ | 83% 142 MB
|============================================================================ | 83% 142 MB
|============================================================================ | 83% 142 MB
|============================================================================ | 83% 142 MB
|============================================================================ | 84% 142 MB
|============================================================================ | 84% 143 MB
|============================================================================ | 84% 143 MB
|============================================================================ | 84% 143 MB
|============================================================================ | 84% 143 MB
|============================================================================ | 84% 143 MB
|============================================================================ | 84% 143 MB
|============================================================================ | 84% 143 MB
|============================================================================ | 84% 143 MB
|============================================================================= | 84% 143 MB
|============================================================================= | 84% 144 MB
|============================================================================= | 84% 144 MB
|============================================================================= | 84% 144 MB
|============================================================================= | 84% 144 MB
|============================================================================= | 85% 144 MB
|============================================================================= | 85% 144 MB
|============================================================================= | 85% 144 MB
|============================================================================= | 85% 144 MB
|============================================================================= | 85% 144 MB
|============================================================================= | 85% 145 MB
|============================================================================= | 85% 145 MB
|============================================================================= | 85% 145 MB
|============================================================================= | 85% 145 MB
|============================================================================= | 85% 145 MB
|============================================================================= | 85% 145 MB
|============================================================================== | 85% 145 MB
|============================================================================== | 85% 145 MB
|============================================================================== | 85% 145 MB
|============================================================================== | 85% 146 MB
|============================================================================== | 86% 146 MB
|============================================================================== | 86% 146 MB
|============================================================================== | 86% 146 MB
|============================================================================== | 86% 146 MB
|============================================================================== | 86% 146 MB
|============================================================================== | 86% 146 MB
|============================================================================== | 86% 146 MB
|============================================================================== | 86% 147 MB
|============================================================================== | 86% 147 MB
|============================================================================== | 86% 147 MB
|============================================================================== | 86% 147 MB
|============================================================================== | 86% 147 MB
|=============================================================================== | 86% 147 MB
|=============================================================================== | 86% 147 MB
|=============================================================================== | 86% 147 MB
|=============================================================================== | 87% 147 MB
|=============================================================================== | 87% 148 MB
|=============================================================================== | 87% 148 MB
|=============================================================================== | 87% 148 MB
|=============================================================================== | 87% 148 MB
|=============================================================================== | 87% 148 MB
|=============================================================================== | 87% 148 MB
|=============================================================================== | 87% 148 MB
|=============================================================================== | 87% 148 MB
|=============================================================================== | 87% 149 MB
|=============================================================================== | 87% 149 MB
|=============================================================================== | 87% 149 MB
|=============================================================================== | 87% 149 MB
|=============================================================================== | 87% 149 MB
|================================================================================ | 87% 149 MB
|================================================================================ | 88% 149 MB
|================================================================================ | 88% 149 MB
|================================================================================ | 88% 149 MB
|================================================================================ | 88% 150 MB
|================================================================================ | 88% 150 MB
|================================================================================ | 88% 150 MB
|================================================================================ | 88% 150 MB
|================================================================================ | 88% 150 MB
|================================================================================ | 88% 150 MB
|================================================================================ | 88% 150 MB
|================================================================================ | 88% 150 MB
|================================================================================ | 88% 150 MB
|================================================================================ | 88% 151 MB
|================================================================================ | 88% 151 MB
|================================================================================ | 89% 151 MB
|================================================================================= | 89% 151 MB
|================================================================================= | 89% 151 MB
|================================================================================= | 89% 151 MB
|================================================================================= | 89% 151 MB
|================================================================================= | 89% 151 MB
|================================================================================= | 89% 152 MB
|================================================================================= | 89% 152 MB
|================================================================================= | 89% 152 MB
|================================================================================= | 89% 152 MB
|================================================================================= | 89% 152 MB
|================================================================================= | 89% 152 MB
|================================================================================= | 89% 152 MB
|================================================================================= | 89% 152 MB
|================================================================================= | 89% 152 MB
|================================================================================= | 90% 153 MB
|================================================================================= | 90% 153 MB
|================================================================================== | 90% 153 MB
|================================================================================== | 90% 153 MB
|================================================================================== | 90% 153 MB
|================================================================================== | 90% 153 MB
|================================================================================== | 90% 153 MB
|================================================================================== | 90% 153 MB
|================================================================================== | 90% 153 MB
|================================================================================== | 90% 154 MB
|================================================================================== | 90% 154 MB
|================================================================================== | 90% 154 MB
|================================================================================== | 90% 154 MB
|================================================================================== | 90% 154 MB
|================================================================================== | 90% 154 MB
|================================================================================== | 91% 154 MB
|================================================================================== | 91% 154 MB
|================================================================================== | 91% 155 MB
|=================================================================================== | 91% 155 MB
|=================================================================================== | 91% 155 MB
|=================================================================================== | 91% 155 MB
|=================================================================================== | 91% 155 MB
|=================================================================================== | 91% 155 MB
|=================================================================================== | 91% 155 MB
|=================================================================================== | 91% 155 MB
|=================================================================================== | 91% 155 MB
|=================================================================================== | 91% 156 MB
|=================================================================================== | 91% 156 MB
|=================================================================================== | 91% 156 MB
|=================================================================================== | 92% 156 MB
|=================================================================================== | 92% 156 MB
|=================================================================================== | 92% 156 MB
|=================================================================================== | 92% 156 MB
|=================================================================================== | 92% 156 MB
|==================================================================================== | 92% 156 MB
|==================================================================================== | 92% 157 MB
|==================================================================================== | 92% 157 MB
|==================================================================================== | 92% 157 MB
|==================================================================================== | 92% 157 MB
|==================================================================================== | 92% 157 MB
|==================================================================================== | 92% 157 MB
|==================================================================================== | 92% 157 MB
|==================================================================================== | 92% 157 MB
|==================================================================================== | 92% 158 MB
|==================================================================================== | 93% 158 MB
|==================================================================================== | 93% 158 MB
|==================================================================================== | 93% 158 MB
|==================================================================================== | 93% 158 MB
|==================================================================================== | 93% 158 MB
|==================================================================================== | 93% 158 MB
|===================================================================================== | 93% 158 MB
|===================================================================================== | 93% 158 MB
|===================================================================================== | 93% 159 MB
|===================================================================================== | 93% 159 MB
|===================================================================================== | 93% 159 MB
|===================================================================================== | 93% 159 MB
|===================================================================================== | 93% 159 MB
|===================================================================================== | 93% 159 MB
|===================================================================================== | 93% 159 MB
|===================================================================================== | 94% 159 MB
|===================================================================================== | 94% 160 MB
|===================================================================================== | 94% 160 MB
|===================================================================================== | 94% 160 MB
|===================================================================================== | 94% 160 MB
|===================================================================================== | 94% 160 MB
|===================================================================================== | 94% 160 MB
|====================================================================================== | 94% 160 MB
|====================================================================================== | 94% 160 MB
|====================================================================================== | 94% 160 MB
|====================================================================================== | 94% 161 MB
|====================================================================================== | 94% 161 MB
|====================================================================================== | 94% 161 MB
|====================================================================================== | 94% 161 MB
|====================================================================================== | 95% 161 MB
|====================================================================================== | 95% 161 MB
|====================================================================================== | 95% 161 MB
|====================================================================================== | 95% 161 MB
|====================================================================================== | 95% 162 MB
|====================================================================================== | 95% 162 MB
|====================================================================================== | 95% 162 MB
|====================================================================================== | 95% 162 MB
|====================================================================================== | 95% 162 MB
|======================================================================================= | 95% 162 MB
|======================================================================================= | 95% 162 MB
|======================================================================================= | 95% 162 MB
|======================================================================================= | 95% 162 MB
|======================================================================================= | 95% 163 MB
|======================================================================================= | 95% 163 MB
|======================================================================================= | 96% 163 MB
|======================================================================================= | 96% 163 MB
|======================================================================================= | 96% 163 MB
|======================================================================================= | 96% 163 MB
|======================================================================================= | 96% 163 MB
|======================================================================================= | 96% 163 MB
|======================================================================================= | 96% 164 MB
|======================================================================================= | 96% 164 MB
|======================================================================================= | 96% 164 MB
|======================================================================================= | 96% 164 MB
|======================================================================================== | 96% 164 MB
|======================================================================================== | 96% 164 MB
|======================================================================================== | 96% 164 MB
|======================================================================================== | 96% 164 MB
|======================================================================================== | 97% 165 MB
|======================================================================================== | 97% 165 MB
|======================================================================================== | 97% 165 MB
|======================================================================================== | 97% 165 MB
|======================================================================================== | 97% 165 MB
|======================================================================================== | 97% 165 MB
|======================================================================================== | 97% 165 MB
|======================================================================================== | 97% 165 MB
|======================================================================================== | 97% 165 MB
|======================================================================================== | 97% 166 MB
|======================================================================================== | 97% 166 MB
|========================================================================================= | 97% 166 MB
|========================================================================================= | 97% 166 MB
|========================================================================================= | 97% 166 MB
|========================================================================================= | 98% 166 MB
|========================================================================================= | 98% 166 MB
|========================================================================================= | 98% 166 MB
|========================================================================================= | 98% 167 MB
|========================================================================================= | 98% 167 MB
|========================================================================================= | 98% 167 MB
|========================================================================================= | 98% 167 MB
|========================================================================================= | 98% 167 MB
|========================================================================================= | 98% 167 MB
|========================================================================================= | 98% 167 MB
|========================================================================================= | 98% 167 MB
|========================================================================================= | 98% 168 MB
|========================================================================================= | 98% 168 MB
|==========================================================================================| 98% 168 MB
|==========================================================================================| 99% 168 MB
|==========================================================================================| 99% 168 MB
|==========================================================================================| 99% 168 MB
|==========================================================================================| 99% 168 MB
|==========================================================================================| 99% 168 MB
|==========================================================================================| 99% 168 MB
|==========================================================================================| 99% 169 MB
|==========================================================================================| 99% 169 MB
|==========================================================================================| 99% 169 MB
|==========================================================================================| 99% 169 MB
|==========================================================================================| 99% 169 MB
|==========================================================================================| 99% 169 MB
|==========================================================================================| 99% 169 MB
|==========================================================================================| 99% 169 MB
|==========================================================================================| 99% 169 MB
|===========================================================================================| 100% 170 MB
#read the downloaded file for all the building permits and then filter out the permits for dismantling
dismantle_permits <- read_csv("./data/Building_Permits_3_19_2018.csv",
guess_max = 10^6) %>%
filter(`Building Permit Type` == "Dismantle")
Parsed with column specification:
cols(
.default = col_character(),
`Parcel Size` = col_double(),
`Parcel Cluster Sector` = col_integer(),
Stories = col_double(),
`Parcel Floor Area` = col_integer(),
`Parcel Ground Area` = col_integer(),
`Sequence Number` = col_integer()
)
See spec(...) for full column specifications.
#the files that contain the crime data
crime_to_12062016 <-
read_csv("./data/DPD__All_Crime_Incidents__January_1__2009_-_December_6__2016.csv",
guess_max = 10^6)
Parsed with column specification:
cols(
ROWNUM = col_integer(),
CASEID = col_integer(),
CRIMEID = col_integer(),
CRNO = col_character(),
CATEGORY = col_character(),
OFFENSEDESCRIPTION = col_character(),
STATEOFFENSEFILECLASS = col_integer(),
INCIDENTDATE = col_character(),
HOUR = col_integer(),
SCA = col_integer(),
PRECINCT = col_integer(),
COUNCIL = col_character(),
NEIGHBORHOOD = col_character(),
CENSUSTRACT = col_double(),
LOCATION = col_character()
)
| | 0%
| | 0%
| | 0%
| | 0%
| | 0%
| | 0%
| | 0%
| | 0% 1 MB
| | 0% 1 MB
| | 0% 1 MB
| | 0% 1 MB
| | 0% 1 MB
| | 0% 1 MB
| | 0% 1 MB
| | 0% 1 MB
| | 0% 2 MB
| | 0% 2 MB
| | 1% 2 MB
| | 1% 2 MB
|= | 1% 2 MB
|= | 1% 2 MB
|= | 1% 2 MB
|= | 1% 2 MB
|= | 1% 3 MB
|= | 1% 3 MB
|= | 1% 3 MB
|= | 1% 3 MB
|= | 1% 3 MB
|= | 1% 3 MB
|= | 1% 3 MB
|= | 1% 4 MB
|= | 1% 4 MB
|= | 1% 4 MB
|= | 1% 4 MB
|= | 1% 4 MB
|= | 2% 4 MB
|= | 2% 4 MB
|= | 2% 4 MB
|= | 2% 5 MB
|== | 2% 5 MB
|== | 2% 5 MB
|== | 2% 5 MB
|== | 2% 5 MB
|== | 2% 5 MB
|== | 2% 5 MB
|== | 2% 5 MB
|== | 2% 6 MB
|== | 2% 6 MB
|== | 2% 6 MB
|== | 2% 6 MB
|== | 2% 6 MB
|== | 2% 6 MB
|== | 2% 6 MB
|== | 3% 6 MB
|== | 3% 7 MB
|== | 3% 7 MB
|== | 3% 7 MB
|== | 3% 7 MB
|== | 3% 7 MB
|=== | 3% 7 MB
|=== | 3% 7 MB
|=== | 3% 7 MB
|=== | 3% 8 MB
|=== | 3% 8 MB
|=== | 3% 8 MB
|=== | 3% 8 MB
|=== | 3% 8 MB
|=== | 3% 8 MB
|=== | 3% 8 MB
|=== | 3% 8 MB
|=== | 3% 9 MB
|=== | 3% 9 MB
|=== | 4% 9 MB
|=== | 4% 9 MB
|=== | 4% 9 MB
|=== | 4% 9 MB
|=== | 4% 9 MB
|=== | 4% 9 MB
|=== | 4% 10 MB
|==== | 4% 10 MB
|==== | 4% 10 MB
|==== | 4% 10 MB
|==== | 4% 10 MB
|==== | 4% 10 MB
|==== | 4% 10 MB
|==== | 4% 10 MB
|==== | 4% 11 MB
|==== | 4% 11 MB
|==== | 4% 11 MB
|==== | 4% 11 MB
|==== | 5% 11 MB
|==== | 5% 11 MB
|==== | 5% 11 MB
|==== | 5% 11 MB
|==== | 5% 12 MB
|==== | 5% 12 MB
|==== | 5% 12 MB
|==== | 5% 12 MB
|==== | 5% 12 MB
|===== | 5% 12 MB
|===== | 5% 12 MB
|===== | 5% 12 MB
|===== | 5% 13 MB
|===== | 5% 13 MB
|===== | 5% 13 MB
|===== | 5% 13 MB
|===== | 5% 13 MB
|===== | 5% 13 MB
|===== | 6% 13 MB
|===== | 6% 13 MB
|===== | 6% 14 MB
|===== | 6% 14 MB
|===== | 6% 14 MB
|===== | 6% 14 MB
|===== | 6% 14 MB
|===== | 6% 14 MB
|===== | 6% 14 MB
|===== | 6% 14 MB
|===== | 6% 15 MB
|====== | 6% 15 MB
|====== | 6% 15 MB
|====== | 6% 15 MB
|====== | 6% 15 MB
|====== | 6% 15 MB
|====== | 6% 15 MB
|====== | 6% 15 MB
|====== | 7% 16 MB
|====== | 7% 16 MB
|====== | 7% 16 MB
|====== | 7% 16 MB
|====== | 7% 16 MB
|====== | 7% 16 MB
|====== | 7% 16 MB
|====== | 7% 16 MB
|====== | 7% 17 MB
|====== | 7% 17 MB
|====== | 7% 17 MB
|====== | 7% 17 MB
|======= | 7% 17 MB
|======= | 7% 17 MB
|======= | 7% 17 MB
|======= | 7% 18 MB
|======= | 7% 18 MB
|======= | 7% 18 MB
|======= | 8% 18 MB
|======= | 8% 18 MB
|======= | 8% 18 MB
|======= | 8% 18 MB
|======= | 8% 18 MB
|======= | 8% 19 MB
|======= | 8% 19 MB
|======= | 8% 19 MB
|======= | 8% 19 MB
|======= | 8% 19 MB
|======= | 8% 19 MB
|======= | 8% 19 MB
|======= | 8% 19 MB
|======= | 8% 20 MB
|======== | 8% 20 MB
|======== | 8% 20 MB
|======== | 8% 20 MB
|======== | 8% 20 MB
|======== | 9% 20 MB
|======== | 9% 20 MB
|======== | 9% 20 MB
|======== | 9% 21 MB
|======== | 9% 21 MB
|======== | 9% 21 MB
|======== | 9% 21 MB
|======== | 9% 21 MB
|======== | 9% 21 MB
|======== | 9% 21 MB
|======== | 9% 21 MB
|======== | 9% 22 MB
|======== | 9% 22 MB
|======== | 9% 22 MB
|======== | 9% 22 MB
|======== | 9% 22 MB
|========= | 9% 22 MB
|========= | 9% 22 MB
|========= | 10% 22 MB
|========= | 10% 23 MB
|========= | 10% 23 MB
|========= | 10% 23 MB
|========= | 10% 23 MB
|========= | 10% 23 MB
|========= | 10% 23 MB
|========= | 10% 23 MB
|========= | 10% 23 MB
|========= | 10% 24 MB
|========= | 10% 24 MB
|========= | 10% 24 MB
|========= | 10% 24 MB
|========= | 10% 24 MB
|========= | 10% 24 MB
|========= | 10% 24 MB
|========= | 10% 24 MB
|========= | 10% 25 MB
|========== | 11% 25 MB
|========== | 11% 25 MB
|========== | 11% 25 MB
|========== | 11% 25 MB
|========== | 11% 25 MB
|========== | 11% 25 MB
|========== | 11% 26 MB
|========== | 11% 26 MB
|========== | 11% 26 MB
|========== | 11% 26 MB
|========== | 11% 26 MB
|========== | 11% 26 MB
|========== | 11% 26 MB
|========== | 11% 26 MB
|========== | 11% 27 MB
|========== | 11% 27 MB
|========== | 11% 27 MB
|========== | 11% 27 MB
|========== | 12% 27 MB
|========== | 12% 27 MB
|=========== | 12% 27 MB
|=========== | 12% 27 MB
|=========== | 12% 28 MB
|=========== | 12% 28 MB
|=========== | 12% 28 MB
|=========== | 12% 28 MB
|=========== | 12% 28 MB
|=========== | 12% 28 MB
|=========== | 12% 28 MB
|=========== | 12% 28 MB
|=========== | 12% 29 MB
|=========== | 12% 29 MB
|=========== | 12% 29 MB
|=========== | 12% 29 MB
|=========== | 12% 29 MB
|=========== | 12% 29 MB
|=========== | 13% 29 MB
|=========== | 13% 29 MB
|=========== | 13% 30 MB
|============ | 13% 30 MB
|============ | 13% 30 MB
|============ | 13% 30 MB
|============ | 13% 30 MB
|============ | 13% 30 MB
|============ | 13% 30 MB
|============ | 13% 30 MB
|============ | 13% 31 MB
|============ | 13% 31 MB
|============ | 13% 31 MB
|============ | 13% 31 MB
|============ | 13% 31 MB
|============ | 13% 31 MB
|============ | 13% 31 MB
|============ | 13% 31 MB
|============ | 14% 32 MB
|============ | 14% 32 MB
|============ | 14% 32 MB
|============ | 14% 32 MB
|============ | 14% 32 MB
|============= | 14% 32 MB
|============= | 14% 32 MB
|============= | 14% 33 MB
|============= | 14% 33 MB
|============= | 14% 33 MB
|============= | 14% 33 MB
|============= | 14% 33 MB
|============= | 14% 33 MB
|============= | 14% 33 MB
|============= | 14% 33 MB
|============= | 14% 34 MB
|============= | 14% 34 MB
|============= | 14% 34 MB
|============= | 15% 34 MB
|============= | 15% 34 MB
|============= | 15% 34 MB
|============= | 15% 34 MB
|============= | 15% 34 MB
|============= | 15% 35 MB
|============= | 15% 35 MB
|============== | 15% 35 MB
|============== | 15% 35 MB
|============== | 15% 35 MB
|============== | 15% 35 MB
|============== | 15% 35 MB
|============== | 15% 35 MB
|============== | 15% 36 MB
|============== | 15% 36 MB
|============== | 15% 36 MB
|============== | 15% 36 MB
|============== | 15% 36 MB
|============== | 16% 36 MB
|============== | 16% 36 MB
|============== | 16% 36 MB
|============== | 16% 37 MB
|============== | 16% 37 MB
|============== | 16% 37 MB
|============== | 16% 37 MB
|============== | 16% 37 MB
|============== | 16% 37 MB
|=============== | 16% 37 MB
|=============== | 16% 37 MB
|=============== | 16% 38 MB
|=============== | 16% 38 MB
|=============== | 16% 38 MB
|=============== | 16% 38 MB
|=============== | 16% 38 MB
|=============== | 16% 38 MB
|=============== | 16% 38 MB
|=============== | 16% 38 MB
|=============== | 17% 39 MB
|=============== | 17% 39 MB
|=============== | 17% 39 MB
|=============== | 17% 39 MB
|=============== | 17% 39 MB
|=============== | 17% 39 MB
|=============== | 17% 39 MB
|=============== | 17% 39 MB
|=============== | 17% 40 MB
|=============== | 17% 40 MB
|================ | 17% 40 MB
|================ | 17% 40 MB
|================ | 17% 40 MB
|================ | 17% 40 MB
|================ | 17% 40 MB
|================ | 17% 40 MB
|================ | 17% 41 MB
|================ | 17% 41 MB
|================ | 18% 41 MB
|================ | 18% 41 MB
|================ | 18% 41 MB
|================ | 18% 41 MB
|================ | 18% 41 MB
|================ | 18% 41 MB
|================ | 18% 42 MB
|================ | 18% 42 MB
|================ | 18% 42 MB
|================ | 18% 42 MB
|================ | 18% 42 MB
|================ | 18% 42 MB
|================= | 18% 42 MB
|================= | 18% 43 MB
|================= | 18% 43 MB
|================= | 18% 43 MB
|================= | 18% 43 MB
|================= | 18% 43 MB
|================= | 19% 43 MB
|================= | 19% 43 MB
|================= | 19% 43 MB
|================= | 19% 44 MB
|================= | 19% 44 MB
|================= | 19% 44 MB
|================= | 19% 44 MB
|================= | 19% 44 MB
|================= | 19% 44 MB
|================= | 19% 44 MB
|================= | 19% 44 MB
|================= | 19% 45 MB
|================= | 19% 45 MB
|================= | 19% 45 MB
|================== | 19% 45 MB
|================== | 19% 45 MB
|================== | 19% 45 MB
|================== | 19% 45 MB
|================== | 20% 45 MB
|================== | 20% 46 MB
|================== | 20% 46 MB
|================== | 20% 46 MB
|================== | 20% 46 MB
|================== | 20% 46 MB
|================== | 20% 46 MB
|================== | 20% 46 MB
|================== | 20% 46 MB
|================== | 20% 47 MB
|================== | 20% 47 MB
|================== | 20% 47 MB
|================== | 20% 47 MB
|================== | 20% 47 MB
|================== | 20% 47 MB
|================== | 20% 47 MB
|=================== | 20% 47 MB
|=================== | 20% 48 MB
|=================== | 21% 48 MB
|=================== | 21% 48 MB
|=================== | 21% 48 MB
|=================== | 21% 48 MB
|=================== | 21% 48 MB
|=================== | 21% 48 MB
|=================== | 21% 48 MB
|=================== | 21% 49 MB
|=================== | 21% 49 MB
|=================== | 21% 49 MB
|=================== | 21% 49 MB
|=================== | 21% 49 MB
|=================== | 21% 49 MB
|=================== | 21% 49 MB
|=================== | 21% 49 MB
|=================== | 21% 50 MB
|=================== | 21% 50 MB
|==================== | 21% 50 MB
|==================== | 22% 50 MB
|==================== | 22% 50 MB
|==================== | 22% 50 MB
|==================== | 22% 50 MB
|==================== | 22% 50 MB
|==================== | 22% 51 MB
|==================== | 22% 51 MB
|==================== | 22% 51 MB
|==================== | 22% 51 MB
|==================== | 22% 51 MB
|==================== | 22% 51 MB
|==================== | 22% 51 MB
|==================== | 22% 52 MB
|==================== | 22% 52 MB
|==================== | 22% 52 MB
|==================== | 22% 52 MB
|==================== | 22% 52 MB
|==================== | 22% 52 MB
|==================== | 23% 52 MB
|===================== | 23% 52 MB
|===================== | 23% 53 MB
|===================== | 23% 53 MB
|===================== | 23% 53 MB
|===================== | 23% 53 MB
|===================== | 23% 53 MB
|===================== | 23% 53 MB
|===================== | 23% 53 MB
|===================== | 23% 53 MB
|===================== | 23% 54 MB
|===================== | 23% 54 MB
|===================== | 23% 54 MB
|===================== | 23% 54 MB
|===================== | 23% 54 MB
|===================== | 23% 54 MB
|===================== | 23% 54 MB
|===================== | 23% 54 MB
|===================== | 24% 55 MB
|===================== | 24% 55 MB
|===================== | 24% 55 MB
|====================== | 24% 55 MB
|====================== | 24% 55 MB
|====================== | 24% 55 MB
|====================== | 24% 55 MB
|====================== | 24% 55 MB
|====================== | 24% 56 MB
|====================== | 24% 56 MB
|====================== | 24% 56 MB
|====================== | 24% 56 MB
|====================== | 24% 56 MB
|====================== | 24% 56 MB
|====================== | 24% 56 MB
|====================== | 24% 56 MB
|====================== | 24% 57 MB
|====================== | 24% 57 MB
|====================== | 25% 57 MB
|====================== | 25% 57 MB
|====================== | 25% 57 MB
|====================== | 25% 57 MB
|====================== | 25% 57 MB
|======================= | 25% 57 MB
|======================= | 25% 58 MB
|======================= | 25% 58 MB
|======================= | 25% 58 MB
|======================= | 25% 58 MB
|======================= | 25% 58 MB
|======================= | 25% 58 MB
|======================= | 25% 58 MB
|======================= | 25% 58 MB
|======================= | 25% 59 MB
|======================= | 25% 59 MB
|======================= | 25% 59 MB
|======================= | 25% 59 MB
|======================= | 26% 59 MB
|======================= | 26% 59 MB
|======================= | 26% 59 MB
|======================= | 26% 59 MB
|======================= | 26% 60 MB
|======================= | 26% 60 MB
|======================= | 26% 60 MB
|======================== | 26% 60 MB
|======================== | 26% 60 MB
|======================== | 26% 60 MB
|======================== | 26% 60 MB
|======================== | 26% 61 MB
|======================== | 26% 61 MB
|======================== | 26% 61 MB
|======================== | 26% 61 MB
|======================== | 26% 61 MB
|======================== | 26% 61 MB
|======================== | 26% 61 MB
|======================== | 27% 61 MB
|======================== | 27% 62 MB
|======================== | 27% 62 MB
|======================== | 27% 62 MB
|======================== | 27% 62 MB
|======================== | 27% 62 MB
|======================== | 27% 62 MB
|======================== | 27% 62 MB
|======================== | 27% 62 MB
|========================= | 27% 63 MB
|========================= | 27% 63 MB
|========================= | 27% 63 MB
|========================= | 27% 63 MB
|========================= | 27% 63 MB
|========================= | 27% 63 MB
|========================= | 27% 63 MB
|========================= | 27% 63 MB
|========================= | 27% 64 MB
|========================= | 28% 64 MB
|========================= | 28% 64 MB
|========================= | 28% 64 MB
|========================= | 28% 64 MB
|========================= | 28% 64 MB
|========================= | 28% 64 MB
|========================= | 28% 64 MB
|========================= | 28% 65 MB
|========================= | 28% 65 MB
|========================= | 28% 65 MB
|========================= | 28% 65 MB
|========================== | 28% 65 MB
|========================== | 28% 65 MB
|========================== | 28% 65 MB
|========================== | 28% 65 MB
|========================== | 28% 66 MB
|========================== | 28% 66 MB
|========================== | 28% 66 MB
|========================== | 29% 66 MB
|========================== | 29% 66 MB
|========================== | 29% 66 MB
|========================== | 29% 66 MB
|========================== | 29% 66 MB
|========================== | 29% 67 MB
|========================== | 29% 67 MB
|========================== | 29% 67 MB
|========================== | 29% 67 MB
|========================== | 29% 67 MB
|========================== | 29% 67 MB
|========================== | 29% 67 MB
|========================== | 29% 67 MB
|=========================== | 29% 68 MB
|=========================== | 29% 68 MB
|=========================== | 29% 68 MB
|=========================== | 29% 68 MB
|=========================== | 29% 68 MB
|=========================== | 29% 68 MB
|=========================== | 30% 68 MB
|=========================== | 30% 68 MB
|=========================== | 30% 69 MB
|=========================== | 30% 69 MB
|=========================== | 30% 69 MB
|=========================== | 30% 69 MB
|=========================== | 30% 69 MB
|=========================== | 30% 69 MB
|=========================== | 30% 69 MB
|=========================== | 30% 69 MB
|=========================== | 30% 70 MB
|=========================== | 30% 70 MB
|=========================== | 30% 70 MB
|=========================== | 30% 70 MB
|============================ | 30% 70 MB
|============================ | 30% 70 MB
|============================ | 30% 70 MB
|============================ | 30% 70 MB
|============================ | 31% 71 MB
|============================ | 31% 71 MB
|============================ | 31% 71 MB
|============================ | 31% 71 MB
|============================ | 31% 71 MB
|============================ | 31% 71 MB
|============================ | 31% 71 MB
|============================ | 31% 71 MB
|============================ | 31% 72 MB
|============================ | 31% 72 MB
|============================ | 31% 72 MB
|============================ | 31% 72 MB
|============================ | 31% 72 MB
|============================ | 31% 72 MB
|============================ | 31% 72 MB
|============================ | 31% 72 MB
|============================= | 31% 73 MB
|============================= | 31% 73 MB
|============================= | 32% 73 MB
|============================= | 32% 73 MB
|============================= | 32% 73 MB
|============================= | 32% 73 MB
|============================= | 32% 73 MB
|============================= | 32% 73 MB
|============================= | 32% 74 MB
|============================= | 32% 74 MB
|============================= | 32% 74 MB
|============================= | 32% 74 MB
|============================= | 32% 74 MB
|============================= | 32% 74 MB
|============================= | 32% 74 MB
|============================= | 32% 74 MB
|============================= | 32% 75 MB
|============================= | 32% 75 MB
|============================= | 32% 75 MB
|============================= | 32% 75 MB
|============================== | 32% 75 MB
|============================== | 33% 75 MB
|============================== | 33% 75 MB
|============================== | 33% 75 MB
|============================== | 33% 76 MB
|============================== | 33% 76 MB
|============================== | 33% 76 MB
|============================== | 33% 76 MB
|============================== | 33% 76 MB
|============================== | 33% 76 MB
|============================== | 33% 76 MB
|============================== | 33% 76 MB
|============================== | 33% 77 MB
|============================== | 33% 77 MB
|============================== | 33% 77 MB
|============================== | 33% 77 MB
|============================== | 33% 77 MB
|============================== | 33% 77 MB
|============================== | 33% 77 MB
|============================== | 34% 77 MB
|=============================== | 34% 78 MB
|=============================== | 34% 78 MB
|=============================== | 34% 78 MB
|=============================== | 34% 78 MB
|=============================== | 34% 78 MB
|=============================== | 34% 78 MB
|=============================== | 34% 78 MB
|=============================== | 34% 78 MB
|=============================== | 34% 79 MB
|=============================== | 34% 79 MB
|=============================== | 34% 79 MB
|=============================== | 34% 79 MB
|=============================== | 34% 79 MB
|=============================== | 34% 79 MB
|=============================== | 34% 79 MB
|=============================== | 34% 80 MB
|=============================== | 34% 80 MB
|=============================== | 35% 80 MB
|=============================== | 35% 80 MB
|=============================== | 35% 80 MB
|================================ | 35% 80 MB
|================================ | 35% 80 MB
|================================ | 35% 80 MB
|================================ | 35% 81 MB
|================================ | 35% 81 MB
|================================ | 35% 81 MB
|================================ | 35% 81 MB
|================================ | 35% 81 MB
|================================ | 35% 81 MB
|================================ | 35% 81 MB
|================================ | 35% 81 MB
|================================ | 35% 82 MB
|================================ | 35% 82 MB
|================================ | 35% 82 MB
|================================ | 35% 82 MB
|================================ | 36% 82 MB
|================================ | 36% 82 MB
|================================ | 36% 82 MB
|================================ | 36% 82 MB
|================================ | 36% 83 MB
|================================= | 36% 83 MB
|================================= | 36% 83 MB
|================================= | 36% 83 MB
|================================= | 36% 83 MB
|================================= | 36% 83 MB
|================================= | 36% 83 MB
|================================= | 36% 83 MB
|================================= | 36% 84 MB
|================================= | 36% 84 MB
|================================= | 36% 84 MB
|================================= | 36% 84 MB
|================================= | 36% 84 MB
|================================= | 36% 84 MB
|================================= | 37% 84 MB
|================================= | 37% 84 MB
|================================= | 37% 85 MB
|================================= | 37% 85 MB
|================================= | 37% 85 MB
|================================= | 37% 85 MB
|================================= | 37% 85 MB
|================================== | 37% 85 MB
|================================== | 37% 85 MB
|================================== | 37% 85 MB
|================================== | 37% 86 MB
|================================== | 37% 86 MB
|================================== | 37% 86 MB
|================================== | 37% 86 MB
|================================== | 37% 86 MB
|================================== | 37% 86 MB
|================================== | 37% 86 MB
|================================== | 37% 86 MB
|================================== | 37% 87 MB
|================================== | 38% 87 MB
|================================== | 38% 87 MB
|================================== | 38% 87 MB
|================================== | 38% 87 MB
|================================== | 38% 87 MB
|================================== | 38% 87 MB
|================================== | 38% 87 MB
|================================== | 38% 88 MB
|=================================== | 38% 88 MB
|=================================== | 38% 88 MB
|=================================== | 38% 88 MB
|=================================== | 38% 88 MB
|=================================== | 38% 88 MB
|=================================== | 38% 88 MB
|=================================== | 38% 88 MB
|=================================== | 38% 89 MB
|=================================== | 38% 89 MB
|=================================== | 38% 89 MB
|=================================== | 39% 89 MB
|=================================== | 39% 89 MB
|=================================== | 39% 89 MB
|=================================== | 39% 89 MB
|=================================== | 39% 89 MB
|=================================== | 39% 90 MB
|=================================== | 39% 90 MB
|=================================== | 39% 90 MB
|=================================== | 39% 90 MB
|=================================== | 39% 90 MB
|==================================== | 39% 90 MB
|==================================== | 39% 90 MB
|==================================== | 39% 90 MB
|==================================== | 39% 91 MB
|==================================== | 39% 91 MB
|==================================== | 39% 91 MB
|==================================== | 39% 91 MB
|==================================== | 39% 91 MB
|==================================== | 40% 91 MB
|==================================== | 40% 91 MB
|==================================== | 40% 91 MB
|==================================== | 40% 92 MB
|==================================== | 40% 92 MB
|==================================== | 40% 92 MB
|==================================== | 40% 92 MB
|==================================== | 40% 92 MB
|==================================== | 40% 92 MB
|==================================== | 40% 92 MB
|==================================== | 40% 92 MB
|==================================== | 40% 93 MB
|===================================== | 40% 93 MB
|===================================== | 40% 93 MB
|===================================== | 40% 93 MB
|===================================== | 40% 93 MB
|===================================== | 40% 93 MB
|===================================== | 40% 93 MB
|===================================== | 40% 93 MB
|===================================== | 41% 94 MB
|===================================== | 41% 94 MB
|===================================== | 41% 94 MB
|===================================== | 41% 94 MB
|===================================== | 41% 94 MB
|===================================== | 41% 94 MB
|===================================== | 41% 94 MB
|===================================== | 41% 94 MB
|===================================== | 41% 95 MB
|===================================== | 41% 95 MB
|===================================== | 41% 95 MB
|===================================== | 41% 95 MB
|===================================== | 41% 95 MB
|===================================== | 41% 95 MB
|====================================== | 41% 95 MB
|====================================== | 41% 95 MB
|====================================== | 41% 96 MB
|====================================== | 41% 96 MB
|====================================== | 42% 96 MB
|====================================== | 42% 96 MB
|====================================== | 42% 96 MB
|====================================== | 42% 96 MB
|====================================== | 42% 96 MB
|====================================== | 42% 96 MB
|====================================== | 42% 97 MB
|====================================== | 42% 97 MB
|====================================== | 42% 97 MB
|====================================== | 42% 97 MB
|====================================== | 42% 97 MB
|====================================== | 42% 97 MB
|====================================== | 42% 97 MB
|====================================== | 42% 97 MB
|====================================== | 42% 98 MB
|====================================== | 42% 98 MB
|======================================= | 42% 98 MB
|======================================= | 42% 98 MB
|======================================= | 43% 98 MB
|======================================= | 43% 98 MB
|======================================= | 43% 98 MB
|======================================= | 43% 98 MB
|======================================= | 43% 99 MB
|======================================= | 43% 99 MB
|======================================= | 43% 99 MB
|======================================= | 43% 99 MB
|======================================= | 43% 99 MB
|======================================= | 43% 99 MB
|======================================= | 43% 99 MB
|======================================= | 43% 99 MB
|======================================= | 43% 100 MB
|======================================= | 43% 100 MB
|======================================= | 43% 100 MB
|======================================= | 43% 100 MB
|======================================= | 43% 100 MB
|======================================= | 43% 100 MB
|======================================== | 43% 100 MB
|======================================== | 44% 100 MB
|======================================== | 44% 101 MB
|======================================== | 44% 101 MB
|======================================== | 44% 101 MB
|======================================== | 44% 101 MB
|======================================== | 44% 101 MB
|======================================== | 44% 101 MB
|======================================== | 44% 101 MB
|======================================== | 44% 101 MB
|======================================== | 44% 102 MB
|======================================== | 44% 102 MB
|======================================== | 44% 102 MB
|======================================== | 44% 102 MB
|======================================== | 44% 102 MB
|======================================== | 44% 102 MB
|======================================== | 44% 102 MB
|======================================== | 44% 102 MB
|======================================== | 44% 103 MB
|======================================== | 45% 103 MB
|========================================= | 45% 103 MB
|========================================= | 45% 103 MB
|========================================= | 45% 103 MB
|========================================= | 45% 103 MB
|========================================= | 45% 103 MB
|========================================= | 45% 103 MB
|========================================= | 45% 104 MB
|========================================= | 45% 104 MB
|========================================= | 45% 104 MB
|========================================= | 45% 104 MB
|========================================= | 45% 104 MB
|========================================= | 45% 104 MB
|========================================= | 45% 104 MB
|========================================= | 45% 104 MB
|========================================= | 45% 105 MB
|========================================= | 45% 105 MB
|========================================= | 45% 105 MB
|========================================= | 46% 105 MB
|========================================= | 46% 105 MB
|========================================= | 46% 105 MB
|========================================== | 46% 105 MB
|========================================== | 46% 105 MB
|========================================== | 46% 106 MB
|========================================== | 46% 106 MB
|========================================== | 46% 106 MB
|========================================== | 46% 106 MB
|========================================== | 46% 106 MB
|========================================== | 46% 106 MB
|========================================== | 46% 106 MB
|========================================== | 46% 106 MB
|========================================== | 46% 107 MB
|========================================== | 46% 107 MB
|========================================== | 46% 107 MB
|========================================== | 46% 107 MB
|========================================== | 46% 107 MB
|========================================== | 46% 107 MB
|========================================== | 47% 107 MB
|========================================== | 47% 107 MB
|========================================== | 47% 108 MB
|========================================== | 47% 108 MB
|=========================================== | 47% 108 MB
|=========================================== | 47% 108 MB
|=========================================== | 47% 108 MB
|=========================================== | 47% 108 MB
|=========================================== | 47% 108 MB
|=========================================== | 47% 108 MB
|=========================================== | 47% 109 MB
|=========================================== | 47% 109 MB
|=========================================== | 47% 109 MB
|=========================================== | 47% 109 MB
|=========================================== | 47% 109 MB
|=========================================== | 47% 109 MB
|=========================================== | 47% 109 MB
|=========================================== | 47% 109 MB
|=========================================== | 48% 110 MB
|=========================================== | 48% 110 MB
|=========================================== | 48% 110 MB
|=========================================== | 48% 110 MB
|=========================================== | 48% 110 MB
|=========================================== | 48% 110 MB
|============================================ | 48% 110 MB
|============================================ | 48% 110 MB
|============================================ | 48% 111 MB
|============================================ | 48% 111 MB
|============================================ | 48% 111 MB
|============================================ | 48% 111 MB
|============================================ | 48% 111 MB
|============================================ | 48% 111 MB
|============================================ | 48% 111 MB
|============================================ | 48% 111 MB
|============================================ | 48% 112 MB
|============================================ | 48% 112 MB
|============================================ | 49% 112 MB
|============================================ | 49% 112 MB
|============================================ | 49% 112 MB
|============================================ | 49% 112 MB
|============================================ | 49% 112 MB
|============================================ | 49% 112 MB
|============================================ | 49% 113 MB
|============================================ | 49% 113 MB
|============================================= | 49% 113 MB
|============================================= | 49% 113 MB
|============================================= | 49% 113 MB
|============================================= | 49% 113 MB
|============================================= | 49% 113 MB
|============================================= | 49% 113 MB
|============================================= | 49% 114 MB
|============================================= | 49% 114 MB
|============================================= | 49% 114 MB
|============================================= | 49% 114 MB
|============================================= | 50% 114 MB
|============================================= | 50% 114 MB
|============================================= | 50% 114 MB
|============================================= | 50% 114 MB
|============================================= | 50% 115 MB
|============================================= | 50% 115 MB
|============================================= | 50% 115 MB
|============================================= | 50% 115 MB
|============================================= | 50% 115 MB
|============================================= | 50% 115 MB
|============================================= | 50% 115 MB
|============================================== | 50% 115 MB
|============================================== | 50% 116 MB
|============================================== | 50% 116 MB
|============================================== | 50% 116 MB
|============================================== | 50% 116 MB
|============================================== | 50% 116 MB
|============================================== | 50% 116 MB
|============================================== | 50% 116 MB
|============================================== | 51% 116 MB
|============================================== | 51% 117 MB
|============================================== | 51% 117 MB
|============================================== | 51% 117 MB
|============================================== | 51% 117 MB
|============================================== | 51% 117 MB
|============================================== | 51% 117 MB
|============================================== | 51% 117 MB
|============================================== | 51% 117 MB
|============================================== | 51% 118 MB
|============================================== | 51% 118 MB
|=============================================== | 51% 118 MB
|=============================================== | 51% 118 MB
|=============================================== | 51% 118 MB
|=============================================== | 51% 118 MB
|=============================================== | 51% 118 MB
|=============================================== | 51% 118 MB
|=============================================== | 51% 119 MB
|=============================================== | 52% 119 MB
|=============================================== | 52% 119 MB
|=============================================== | 52% 119 MB
|=============================================== | 52% 119 MB
|=============================================== | 52% 119 MB
|=============================================== | 52% 119 MB
|=============================================== | 52% 119 MB
|=============================================== | 52% 120 MB
|=============================================== | 52% 120 MB
|=============================================== | 52% 120 MB
|=============================================== | 52% 120 MB
|=============================================== | 52% 120 MB
|=============================================== | 52% 120 MB
|================================================ | 52% 120 MB
|================================================ | 52% 120 MB
|================================================ | 52% 121 MB
|================================================ | 52% 121 MB
|================================================ | 52% 121 MB
|================================================ | 53% 121 MB
|================================================ | 53% 121 MB
|================================================ | 53% 121 MB
|================================================ | 53% 121 MB
|================================================ | 53% 121 MB
|================================================ | 53% 122 MB
|================================================ | 53% 122 MB
|================================================ | 53% 122 MB
|================================================ | 53% 122 MB
|================================================ | 53% 122 MB
|================================================ | 53% 122 MB
|================================================ | 53% 122 MB
|================================================ | 53% 122 MB
|================================================ | 53% 123 MB
|================================================ | 53% 123 MB
|================================================ | 53% 123 MB
|================================================= | 53% 123 MB
|================================================= | 53% 123 MB
|================================================= | 54% 123 MB
|================================================= | 54% 123 MB
|================================================= | 54% 123 MB
|================================================= | 54% 124 MB
|================================================= | 54% 124 MB
|================================================= | 54% 124 MB
|================================================= | 54% 124 MB
|================================================= | 54% 124 MB
|================================================= | 54% 124 MB
|================================================= | 54% 124 MB
|================================================= | 54% 124 MB
|================================================= | 54% 125 MB
|================================================= | 54% 125 MB
|================================================= | 54% 125 MB
|================================================= | 54% 125 MB
|================================================= | 54% 125 MB
|================================================= | 54% 125 MB
|================================================= | 54% 125 MB
|================================================== | 54% 126 MB
|================================================== | 55% 126 MB
|================================================== | 55% 126 MB
|================================================== | 55% 126 MB
|================================================== | 55% 126 MB
|================================================== | 55% 126 MB
|================================================== | 55% 126 MB
|================================================== | 55% 126 MB
|================================================== | 55% 127 MB
|================================================== | 55% 127 MB
|================================================== | 55% 127 MB
|================================================== | 55% 127 MB
|================================================== | 55% 127 MB
|================================================== | 55% 127 MB
|================================================== | 55% 127 MB
|================================================== | 55% 127 MB
|================================================== | 55% 128 MB
|================================================== | 55% 128 MB
|================================================== | 55% 128 MB
|================================================== | 56% 128 MB
|=================================================== | 56% 128 MB
|=================================================== | 56% 128 MB
|=================================================== | 56% 128 MB
|=================================================== | 56% 128 MB
|=================================================== | 56% 129 MB
|=================================================== | 56% 129 MB
|=================================================== | 56% 129 MB
|=================================================== | 56% 129 MB
|=================================================== | 56% 129 MB
|=================================================== | 56% 129 MB
|=================================================== | 56% 129 MB
|=================================================== | 56% 129 MB
|=================================================== | 56% 130 MB
|=================================================== | 56% 130 MB
|=================================================== | 56% 130 MB
|=================================================== | 56% 130 MB
|=================================================== | 56% 130 MB
|=================================================== | 57% 130 MB
|=================================================== | 57% 130 MB
|=================================================== | 57% 130 MB
|==================================================== | 57% 131 MB
|==================================================== | 57% 131 MB
|==================================================== | 57% 131 MB
|==================================================== | 57% 131 MB
|==================================================== | 57% 131 MB
|==================================================== | 57% 131 MB
|==================================================== | 57% 131 MB
|==================================================== | 57% 131 MB
|==================================================== | 57% 132 MB
|==================================================== | 57% 132 MB
|==================================================== | 57% 132 MB
|==================================================== | 57% 132 MB
|==================================================== | 57% 132 MB
|==================================================== | 57% 132 MB
|==================================================== | 57% 132 MB
|==================================================== | 58% 132 MB
|==================================================== | 58% 133 MB
|==================================================== | 58% 133 MB
|==================================================== | 58% 133 MB
|==================================================== | 58% 133 MB
|===================================================== | 58% 133 MB
|===================================================== | 58% 133 MB
|===================================================== | 58% 133 MB
|===================================================== | 58% 133 MB
|===================================================== | 58% 134 MB
|===================================================== | 58% 134 MB
|===================================================== | 58% 134 MB
|===================================================== | 58% 134 MB
|===================================================== | 58% 134 MB
|===================================================== | 58% 134 MB
|===================================================== | 58% 134 MB
|===================================================== | 58% 134 MB
|===================================================== | 58% 135 MB
|===================================================== | 58% 135 MB
|===================================================== | 59% 135 MB
|===================================================== | 59% 135 MB
|===================================================== | 59% 135 MB
|===================================================== | 59% 135 MB
|===================================================== | 59% 135 MB
|===================================================== | 59% 135 MB
|====================================================== | 59% 136 MB
|====================================================== | 59% 136 MB
|====================================================== | 59% 136 MB
|====================================================== | 59% 136 MB
|====================================================== | 59% 136 MB
|====================================================== | 59% 136 MB
|====================================================== | 59% 136 MB
|====================================================== | 59% 136 MB
|====================================================== | 59% 137 MB
|====================================================== | 59% 137 MB
|====================================================== | 59% 137 MB
|====================================================== | 59% 137 MB
|====================================================== | 60% 137 MB
|====================================================== | 60% 137 MB
|====================================================== | 60% 137 MB
|====================================================== | 60% 137 MB
|====================================================== | 60% 138 MB
|====================================================== | 60% 138 MB
|====================================================== | 60% 138 MB
|====================================================== | 60% 138 MB
|======================================================= | 60% 138 MB
|======================================================= | 60% 138 MB
|======================================================= | 60% 138 MB
|======================================================= | 60% 138 MB
|======================================================= | 60% 139 MB
|======================================================= | 60% 139 MB
|======================================================= | 60% 139 MB
|======================================================= | 60% 139 MB
|======================================================= | 60% 139 MB
|======================================================= | 60% 139 MB
|======================================================= | 61% 139 MB
|======================================================= | 61% 139 MB
|======================================================= | 61% 140 MB
|======================================================= | 61% 140 MB
|======================================================= | 61% 140 MB
|======================================================= | 61% 140 MB
|======================================================= | 61% 140 MB
|======================================================= | 61% 140 MB
|======================================================= | 61% 140 MB
|======================================================= | 61% 140 MB
|======================================================== | 61% 141 MB
|======================================================== | 61% 141 MB
|======================================================== | 61% 141 MB
|======================================================== | 61% 141 MB
|======================================================== | 61% 141 MB
|======================================================== | 61% 141 MB
|======================================================== | 61% 141 MB
|======================================================== | 61% 141 MB
|======================================================== | 62% 142 MB
|======================================================== | 62% 142 MB
|======================================================== | 62% 142 MB
|======================================================== | 62% 142 MB
|======================================================== | 62% 142 MB
|======================================================== | 62% 142 MB
|======================================================== | 62% 142 MB
|======================================================== | 62% 142 MB
|======================================================== | 62% 143 MB
|======================================================== | 62% 143 MB
|======================================================== | 62% 143 MB
|======================================================== | 62% 143 MB
|========================================================= | 62% 143 MB
|========================================================= | 62% 143 MB
|========================================================= | 62% 143 MB
|========================================================= | 62% 143 MB
|========================================================= | 62% 144 MB
|========================================================= | 62% 144 MB
|========================================================= | 63% 144 MB
|========================================================= | 63% 144 MB
|========================================================= | 63% 144 MB
|========================================================= | 63% 144 MB
|========================================================= | 63% 144 MB
|========================================================= | 63% 144 MB
|========================================================= | 63% 145 MB
|========================================================= | 63% 145 MB
|========================================================= | 63% 145 MB
|========================================================= | 63% 145 MB
|========================================================= | 63% 145 MB
|========================================================= | 63% 145 MB
|========================================================= | 63% 145 MB
|========================================================= | 63% 145 MB
|========================================================== | 63% 146 MB
|========================================================== | 63% 146 MB
|========================================================== | 63% 146 MB
|========================================================== | 63% 146 MB
|========================================================== | 63% 146 MB
|========================================================== | 64% 146 MB
|========================================================== | 64% 146 MB
|========================================================== | 64% 146 MB
|========================================================== | 64% 147 MB
|========================================================== | 64% 147 MB
|========================================================== | 64% 147 MB
|========================================================== | 64% 147 MB
|========================================================== | 64% 147 MB
|========================================================== | 64% 147 MB
|========================================================== | 64% 147 MB
|========================================================== | 64% 147 MB
|========================================================== | 64% 148 MB
|========================================================== | 64% 148 MB
|========================================================== | 64% 148 MB
|========================================================== | 64% 148 MB
|=========================================================== | 64% 148 MB
|=========================================================== | 64% 148 MB
|=========================================================== | 64% 148 MB
|=========================================================== | 65% 149 MB
|=========================================================== | 65% 149 MB
|=========================================================== | 65% 149 MB
|=========================================================== | 65% 149 MB
|=========================================================== | 65% 149 MB
|=========================================================== | 65% 149 MB
|=========================================================== | 65% 149 MB
|=========================================================== | 65% 149 MB
|=========================================================== | 65% 150 MB
|=========================================================== | 65% 150 MB
|=========================================================== | 65% 150 MB
|=========================================================== | 65% 150 MB
|=========================================================== | 65% 150 MB
|=========================================================== | 65% 150 MB
|=========================================================== | 65% 150 MB
|=========================================================== | 65% 150 MB
|=========================================================== | 65% 151 MB
|============================================================ | 65% 151 MB
|============================================================ | 66% 151 MB
|============================================================ | 66% 151 MB
|============================================================ | 66% 151 MB
|============================================================ | 66% 151 MB
|============================================================ | 66% 151 MB
|============================================================ | 66% 151 MB
|============================================================ | 66% 152 MB
|============================================================ | 66% 152 MB
|============================================================ | 66% 152 MB
|============================================================ | 66% 152 MB
|============================================================ | 66% 152 MB
|============================================================ | 66% 152 MB
|============================================================ | 66% 152 MB
|============================================================ | 66% 152 MB
|============================================================ | 66% 153 MB
|============================================================ | 66% 153 MB
|============================================================ | 66% 153 MB
|============================================================ | 66% 153 MB
|============================================================ | 67% 153 MB
|============================================================= | 67% 153 MB
|============================================================= | 67% 153 MB
|============================================================= | 67% 153 MB
|============================================================= | 67% 154 MB
|============================================================= | 67% 154 MB
|============================================================= | 67% 154 MB
|============================================================= | 67% 154 MB
|============================================================= | 67% 154 MB
|============================================================= | 67% 154 MB
|============================================================= | 67% 154 MB
|============================================================= | 67% 154 MB
|============================================================= | 67% 155 MB
|============================================================= | 67% 155 MB
|============================================================= | 67% 155 MB
|============================================================= | 67% 155 MB
|============================================================= | 67% 155 MB
|============================================================= | 67% 155 MB
|============================================================= | 68% 155 MB
|============================================================= | 68% 155 MB
|============================================================= | 68% 156 MB
|============================================================== | 68% 156 MB
|============================================================== | 68% 156 MB
|============================================================== | 68% 156 MB
|============================================================== | 68% 156 MB
|============================================================== | 68% 156 MB
|============================================================== | 68% 156 MB
|============================================================== | 68% 156 MB
|============================================================== | 68% 157 MB
|============================================================== | 68% 157 MB
|============================================================== | 68% 157 MB
|============================================================== | 68% 157 MB
|============================================================== | 68% 157 MB
|============================================================== | 68% 157 MB
|============================================================== | 68% 157 MB
|============================================================== | 68% 157 MB
|============================================================== | 68% 158 MB
|============================================================== | 69% 158 MB
|============================================================== | 69% 158 MB
|============================================================== | 69% 158 MB
|============================================================== | 69% 158 MB
|=============================================================== | 69% 158 MB
|=============================================================== | 69% 158 MB
|=============================================================== | 69% 158 MB
|=============================================================== | 69% 159 MB
|=============================================================== | 69% 159 MB
|=============================================================== | 69% 159 MB
|=============================================================== | 69% 159 MB
|=============================================================== | 69% 159 MB
|=============================================================== | 69% 159 MB
|=============================================================== | 69% 159 MB
|=============================================================== | 69% 159 MB
|=============================================================== | 69% 160 MB
|=============================================================== | 69% 160 MB
|=============================================================== | 69% 160 MB
|=============================================================== | 70% 160 MB
|=============================================================== | 70% 160 MB
|=============================================================== | 70% 160 MB
|=============================================================== | 70% 160 MB
|=============================================================== | 70% 160 MB
|=============================================================== | 70% 161 MB
|================================================================ | 70% 161 MB
|================================================================ | 70% 161 MB
|================================================================ | 70% 161 MB
|================================================================ | 70% 161 MB
|================================================================ | 70% 161 MB
|================================================================ | 70% 161 MB
|================================================================ | 70% 161 MB
|================================================================ | 70% 162 MB
|================================================================ | 70% 162 MB
|================================================================ | 70% 162 MB
|================================================================ | 70% 162 MB
|================================================================ | 70% 162 MB
|================================================================ | 71% 162 MB
|================================================================ | 71% 162 MB
|================================================================ | 71% 162 MB
|================================================================ | 71% 163 MB
|================================================================ | 71% 163 MB
|================================================================ | 71% 163 MB
|================================================================ | 71% 163 MB
|================================================================ | 71% 163 MB
|================================================================= | 71% 163 MB
|================================================================= | 71% 163 MB
|================================================================= | 71% 163 MB
|================================================================= | 71% 164 MB
|================================================================= | 71% 164 MB
|================================================================= | 71% 164 MB
|================================================================= | 71% 164 MB
|================================================================= | 71% 164 MB
|================================================================= | 71% 164 MB
|================================================================= | 71% 164 MB
|================================================================= | 72% 164 MB
|================================================================= | 72% 165 MB
|================================================================= | 72% 165 MB
|================================================================= | 72% 165 MB
|================================================================= | 72% 165 MB
|================================================================= | 72% 165 MB
|================================================================= | 72% 165 MB
|================================================================= | 72% 165 MB
|================================================================= | 72% 165 MB
|================================================================= | 72% 166 MB
|================================================================== | 72% 166 MB
|================================================================== | 72% 166 MB
|================================================================== | 72% 166 MB
|================================================================== | 72% 166 MB
|================================================================== | 72% 166 MB
|================================================================== | 72% 166 MB
|================================================================== | 72% 166 MB
|================================================================== | 72% 167 MB
|================================================================== | 72% 167 MB
|================================================================== | 73% 167 MB
|================================================================== | 73% 167 MB
|================================================================== | 73% 167 MB
|================================================================== | 73% 167 MB
|================================================================== | 73% 167 MB
|================================================================== | 73% 167 MB
|================================================================== | 73% 168 MB
|================================================================== | 73% 168 MB
|================================================================== | 73% 168 MB
|================================================================== | 73% 168 MB
|================================================================== | 73% 168 MB
|=================================================================== | 73% 168 MB
|=================================================================== | 73% 168 MB
|=================================================================== | 73% 168 MB
|=================================================================== | 73% 169 MB
|=================================================================== | 73% 169 MB
|=================================================================== | 73% 169 MB
|=================================================================== | 73% 169 MB
|=================================================================== | 74% 169 MB
|=================================================================== | 74% 169 MB
|=================================================================== | 74% 169 MB
|=================================================================== | 74% 170 MB
|=================================================================== | 74% 170 MB
|=================================================================== | 74% 170 MB
|=================================================================== | 74% 170 MB
|=================================================================== | 74% 170 MB
|=================================================================== | 74% 170 MB
|=================================================================== | 74% 170 MB
|=================================================================== | 74% 170 MB
|=================================================================== | 74% 171 MB
|=================================================================== | 74% 171 MB
|==================================================================== | 74% 171 MB
|==================================================================== | 74% 171 MB
|==================================================================== | 74% 171 MB
|==================================================================== | 74% 171 MB
|==================================================================== | 74% 171 MB
|==================================================================== | 75% 171 MB
|==================================================================== | 75% 172 MB
|==================================================================== | 75% 172 MB
|==================================================================== | 75% 172 MB
|==================================================================== | 75% 172 MB
|==================================================================== | 75% 172 MB
|==================================================================== | 75% 172 MB
|==================================================================== | 75% 172 MB
|==================================================================== | 75% 172 MB
|==================================================================== | 75% 173 MB
|==================================================================== | 75% 173 MB
|==================================================================== | 75% 173 MB
|==================================================================== | 75% 173 MB
|==================================================================== | 75% 173 MB
|==================================================================== | 75% 173 MB
|===================================================================== | 75% 173 MB
|===================================================================== | 75% 173 MB
|===================================================================== | 75% 174 MB
|===================================================================== | 76% 174 MB
|===================================================================== | 76% 174 MB
|===================================================================== | 76% 174 MB
|===================================================================== | 76% 174 MB
|===================================================================== | 76% 174 MB
|===================================================================== | 76% 174 MB
|===================================================================== | 76% 174 MB
|===================================================================== | 76% 175 MB
|===================================================================== | 76% 175 MB
|===================================================================== | 76% 175 MB
|===================================================================== | 76% 175 MB
|===================================================================== | 76% 175 MB
|===================================================================== | 76% 175 MB
|===================================================================== | 76% 175 MB
|===================================================================== | 76% 175 MB
|===================================================================== | 76% 176 MB
|===================================================================== | 76% 176 MB
|====================================================================== | 76% 176 MB
|====================================================================== | 76% 176 MB
|====================================================================== | 77% 176 MB
|====================================================================== | 77% 176 MB
|====================================================================== | 77% 176 MB
|====================================================================== | 77% 176 MB
|====================================================================== | 77% 177 MB
|====================================================================== | 77% 177 MB
|====================================================================== | 77% 177 MB
|====================================================================== | 77% 177 MB
|====================================================================== | 77% 177 MB
|====================================================================== | 77% 177 MB
|====================================================================== | 77% 177 MB
|====================================================================== | 77% 177 MB
|====================================================================== | 77% 178 MB
|====================================================================== | 77% 178 MB
|====================================================================== | 77% 178 MB
|====================================================================== | 77% 178 MB
|====================================================================== | 77% 178 MB
|====================================================================== | 77% 178 MB
|======================================================================= | 78% 178 MB
|======================================================================= | 78% 178 MB
|======================================================================= | 78% 179 MB
|======================================================================= | 78% 179 MB
|======================================================================= | 78% 179 MB
|======================================================================= | 78% 179 MB
|======================================================================= | 78% 179 MB
|======================================================================= | 78% 179 MB
|======================================================================= | 78% 179 MB
|======================================================================= | 78% 179 MB
|======================================================================= | 78% 180 MB
|======================================================================= | 78% 180 MB
|======================================================================= | 78% 180 MB
|======================================================================= | 78% 180 MB
|======================================================================= | 78% 180 MB
|======================================================================= | 78% 180 MB
|======================================================================= | 78% 180 MB
|======================================================================= | 78% 180 MB
|======================================================================= | 79% 181 MB
|======================================================================= | 79% 181 MB
|======================================================================== | 79% 181 MB
|======================================================================== | 79% 181 MB
|======================================================================== | 79% 181 MB
|======================================================================== | 79% 181 MB
|======================================================================== | 79% 181 MB
|======================================================================== | 79% 181 MB
|======================================================================== | 79% 182 MB
|======================================================================== | 79% 182 MB
|======================================================================== | 79% 182 MB
|======================================================================== | 79% 182 MB
|======================================================================== | 79% 182 MB
|======================================================================== | 79% 182 MB
|======================================================================== | 79% 182 MB
|======================================================================== | 79% 182 MB
|======================================================================== | 79% 183 MB
|======================================================================== | 79% 183 MB
|======================================================================== | 80% 183 MB
|======================================================================== | 80% 183 MB
|======================================================================== | 80% 183 MB
|======================================================================== | 80% 183 MB
|========================================================================= | 80% 183 MB
|========================================================================= | 80% 183 MB
|========================================================================= | 80% 184 MB
|========================================================================= | 80% 184 MB
|========================================================================= | 80% 184 MB
|========================================================================= | 80% 184 MB
|========================================================================= | 80% 184 MB
|========================================================================= | 80% 184 MB
|========================================================================= | 80% 184 MB
|========================================================================= | 80% 184 MB
|========================================================================= | 80% 185 MB
|========================================================================= | 80% 185 MB
|========================================================================= | 80% 185 MB
|========================================================================= | 80% 185 MB
|========================================================================= | 81% 185 MB
|========================================================================= | 81% 185 MB
|========================================================================= | 81% 185 MB
|========================================================================= | 81% 185 MB
|========================================================================= | 81% 186 MB
|========================================================================= | 81% 186 MB
|========================================================================== | 81% 186 MB
|========================================================================== | 81% 186 MB
|========================================================================== | 81% 186 MB
|========================================================================== | 81% 186 MB
|========================================================================== | 81% 186 MB
|========================================================================== | 81% 186 MB
|========================================================================== | 81% 187 MB
|========================================================================== | 81% 187 MB
|========================================================================== | 81% 187 MB
|========================================================================== | 81% 187 MB
|========================================================================== | 81% 187 MB
|========================================================================== | 81% 187 MB
|========================================================================== | 81% 187 MB
|========================================================================== | 82% 187 MB
|========================================================================== | 82% 188 MB
|========================================================================== | 82% 188 MB
|========================================================================== | 82% 188 MB
|========================================================================== | 82% 188 MB
|========================================================================== | 82% 188 MB
|========================================================================== | 82% 188 MB
|=========================================================================== | 82% 188 MB
|=========================================================================== | 82% 188 MB
|=========================================================================== | 82% 189 MB
|=========================================================================== | 82% 189 MB
|=========================================================================== | 82% 189 MB
|=========================================================================== | 82% 189 MB
|=========================================================================== | 82% 189 MB
|=========================================================================== | 82% 189 MB
|=========================================================================== | 82% 189 MB
|=========================================================================== | 82% 190 MB
|=========================================================================== | 82% 190 MB
|=========================================================================== | 83% 190 MB
|=========================================================================== | 83% 190 MB
|=========================================================================== | 83% 190 MB
|=========================================================================== | 83% 190 MB
|=========================================================================== | 83% 190 MB
|=========================================================================== | 83% 190 MB
|=========================================================================== | 83% 191 MB
|=========================================================================== | 83% 191 MB
|=========================================================================== | 83% 191 MB
|============================================================================ | 83% 191 MB
|============================================================================ | 83% 191 MB
|============================================================================ | 83% 191 MB
|============================================================================ | 83% 191 MB
|============================================================================ | 83% 191 MB
|============================================================================ | 83% 192 MB
|============================================================================ | 83% 192 MB
|============================================================================ | 83% 192 MB
|============================================================================ | 83% 192 MB
|============================================================================ | 84% 192 MB
|============================================================================ | 84% 192 MB
|============================================================================ | 84% 192 MB
|============================================================================ | 84% 192 MB
|============================================================================ | 84% 193 MB
|============================================================================ | 84% 193 MB
|============================================================================ | 84% 193 MB
|============================================================================ | 84% 193 MB
|============================================================================ | 84% 193 MB
|============================================================================ | 84% 193 MB
|============================================================================ | 84% 193 MB
|============================================================================= | 84% 193 MB
|============================================================================= | 84% 194 MB
|============================================================================= | 84% 194 MB
|============================================================================= | 84% 194 MB
|============================================================================= | 84% 194 MB
|============================================================================= | 84% 194 MB
|============================================================================= | 84% 194 MB
|============================================================================= | 85% 194 MB
|============================================================================= | 85% 194 MB
|============================================================================= | 85% 195 MB
|============================================================================= | 85% 195 MB
|============================================================================= | 85% 195 MB
|============================================================================= | 85% 195 MB
|============================================================================= | 85% 195 MB
|============================================================================= | 85% 195 MB
|============================================================================= | 85% 195 MB
|============================================================================= | 85% 195 MB
|============================================================================= | 85% 196 MB
|============================================================================= | 85% 196 MB
|============================================================================= | 85% 196 MB
|============================================================================== | 85% 196 MB
|============================================================================== | 85% 196 MB
|============================================================================== | 85% 196 MB
|============================================================================== | 85% 196 MB
|============================================================================== | 85% 196 MB
|============================================================================== | 86% 197 MB
|============================================================================== | 86% 197 MB
|============================================================================== | 86% 197 MB
|============================================================================== | 86% 197 MB
|============================================================================== | 86% 197 MB
|============================================================================== | 86% 197 MB
|============================================================================== | 86% 197 MB
|============================================================================== | 86% 197 MB
|============================================================================== | 86% 198 MB
|============================================================================== | 86% 198 MB
|============================================================================== | 86% 198 MB
|============================================================================== | 86% 198 MB
|============================================================================== | 86% 198 MB
|============================================================================== | 86% 198 MB
|============================================================================== | 86% 198 MB
|=============================================================================== | 86% 199 MB
|=============================================================================== | 86% 199 MB
|=============================================================================== | 86% 199 MB
|=============================================================================== | 87% 199 MB
|=============================================================================== | 87% 199 MB
|=============================================================================== | 87% 199 MB
|=============================================================================== | 87% 199 MB
|=============================================================================== | 87% 199 MB
|=============================================================================== | 87% 200 MB
|=============================================================================== | 87% 200 MB
|=============================================================================== | 87% 200 MB
|=============================================================================== | 87% 200 MB
|=============================================================================== | 87% 200 MB
|=============================================================================== | 87% 200 MB
|=============================================================================== | 87% 200 MB
|=============================================================================== | 87% 200 MB
|=============================================================================== | 87% 201 MB
|=============================================================================== | 87% 201 MB
|=============================================================================== | 87% 201 MB
|================================================================================ | 87% 201 MB
|================================================================================ | 87% 201 MB
|================================================================================ | 88% 201 MB
|================================================================================ | 88% 201 MB
|================================================================================ | 88% 201 MB
|================================================================================ | 88% 202 MB
|================================================================================ | 88% 202 MB
|================================================================================ | 88% 202 MB
|================================================================================ | 88% 202 MB
|================================================================================ | 88% 202 MB
|================================================================================ | 88% 202 MB
|================================================================================ | 88% 202 MB
|================================================================================ | 88% 202 MB
|================================================================================ | 88% 203 MB
|================================================================================ | 88% 203 MB
|================================================================================ | 88% 203 MB
|================================================================================ | 88% 203 MB
|================================================================================ | 88% 203 MB
|================================================================================ | 88% 203 MB
|================================================================================ | 88% 203 MB
|================================================================================= | 89% 203 MB
|================================================================================= | 89% 204 MB
|================================================================================= | 89% 204 MB
|================================================================================= | 89% 204 MB
|================================================================================= | 89% 204 MB
|================================================================================= | 89% 204 MB
|================================================================================= | 89% 204 MB
|================================================================================= | 89% 204 MB
|================================================================================= | 89% 204 MB
|================================================================================= | 89% 205 MB
|================================================================================= | 89% 205 MB
|================================================================================= | 89% 205 MB
|================================================================================= | 89% 205 MB
|================================================================================= | 89% 205 MB
|================================================================================= | 89% 205 MB
|================================================================================= | 89% 205 MB
|================================================================================= | 89% 205 MB
|================================================================================= | 89% 206 MB
|================================================================================= | 90% 206 MB
|================================================================================= | 90% 206 MB
|================================================================================== | 90% 206 MB
|================================================================================== | 90% 206 MB
|================================================================================== | 90% 206 MB
|================================================================================== | 90% 206 MB
|================================================================================== | 90% 207 MB
|================================================================================== | 90% 207 MB
|================================================================================== | 90% 207 MB
|================================================================================== | 90% 207 MB
|================================================================================== | 90% 207 MB
|================================================================================== | 90% 207 MB
|================================================================================== | 90% 207 MB
|================================================================================== | 90% 207 MB
|================================================================================== | 90% 208 MB
|================================================================================== | 90% 208 MB
|================================================================================== | 90% 208 MB
|================================================================================== | 90% 208 MB
|================================================================================== | 91% 208 MB
|================================================================================== | 91% 208 MB
|================================================================================== | 91% 208 MB
|================================================================================== | 91% 208 MB
|=================================================================================== | 91% 209 MB
|=================================================================================== | 91% 209 MB
|=================================================================================== | 91% 209 MB
|=================================================================================== | 91% 209 MB
|=================================================================================== | 91% 209 MB
|=================================================================================== | 91% 209 MB
|=================================================================================== | 91% 209 MB
|=================================================================================== | 91% 209 MB
|=================================================================================== | 91% 210 MB
|=================================================================================== | 91% 210 MB
|=================================================================================== | 91% 210 MB
|=================================================================================== | 91% 210 MB
|=================================================================================== | 91% 210 MB
|=================================================================================== | 91% 210 MB
|=================================================================================== | 92% 210 MB
|=================================================================================== | 92% 210 MB
|=================================================================================== | 92% 211 MB
|=================================================================================== | 92% 211 MB
|=================================================================================== | 92% 211 MB
|=================================================================================== | 92% 211 MB
|==================================================================================== | 92% 211 MB
|==================================================================================== | 92% 211 MB
|==================================================================================== | 92% 211 MB
|==================================================================================== | 92% 211 MB
|==================================================================================== | 92% 212 MB
|==================================================================================== | 92% 212 MB
|==================================================================================== | 92% 212 MB
|==================================================================================== | 92% 212 MB
|==================================================================================== | 92% 212 MB
|==================================================================================== | 92% 212 MB
|==================================================================================== | 92% 212 MB
|==================================================================================== | 92% 212 MB
|==================================================================================== | 93% 213 MB
|==================================================================================== | 93% 213 MB
|==================================================================================== | 93% 213 MB
|==================================================================================== | 93% 213 MB
|==================================================================================== | 93% 213 MB
|==================================================================================== | 93% 213 MB
|==================================================================================== | 93% 213 MB
|==================================================================================== | 93% 213 MB
|===================================================================================== | 93% 214 MB
|===================================================================================== | 93% 214 MB
|===================================================================================== | 93% 214 MB
|===================================================================================== | 93% 214 MB
|===================================================================================== | 93% 214 MB
|===================================================================================== | 93% 214 MB
|===================================================================================== | 93% 214 MB
|===================================================================================== | 93% 214 MB
|===================================================================================== | 93% 215 MB
|===================================================================================== | 93% 215 MB
|===================================================================================== | 93% 215 MB
|===================================================================================== | 94% 215 MB
|===================================================================================== | 94% 215 MB
|===================================================================================== | 94% 215 MB
|===================================================================================== | 94% 215 MB
|===================================================================================== | 94% 215 MB
|===================================================================================== | 94% 216 MB
|===================================================================================== | 94% 216 MB
|===================================================================================== | 94% 216 MB
|===================================================================================== | 94% 216 MB
|====================================================================================== | 94% 216 MB
|====================================================================================== | 94% 216 MB
|====================================================================================== | 94% 216 MB
|====================================================================================== | 94% 217 MB
|====================================================================================== | 94% 217 MB
|====================================================================================== | 94% 217 MB
|====================================================================================== | 94% 217 MB
|====================================================================================== | 94% 217 MB
|====================================================================================== | 94% 217 MB
|====================================================================================== | 95% 217 MB
|====================================================================================== | 95% 217 MB
|====================================================================================== | 95% 218 MB
|====================================================================================== | 95% 218 MB
|====================================================================================== | 95% 218 MB
|====================================================================================== | 95% 218 MB
|====================================================================================== | 95% 218 MB
|====================================================================================== | 95% 218 MB
|====================================================================================== | 95% 218 MB
|====================================================================================== | 95% 218 MB
|====================================================================================== | 95% 219 MB
|======================================================================================= | 95% 219 MB
|======================================================================================= | 95% 219 MB
|======================================================================================= | 95% 219 MB
|======================================================================================= | 95% 219 MB
|======================================================================================= | 95% 219 MB
|======================================================================================= | 95% 219 MB
|======================================================================================= | 95% 219 MB
|======================================================================================= | 96% 220 MB
|======================================================================================= | 96% 220 MB
|======================================================================================= | 96% 220 MB
|======================================================================================= | 96% 220 MB
|======================================================================================= | 96% 220 MB
|======================================================================================= | 96% 220 MB
|======================================================================================= | 96% 220 MB
|======================================================================================= | 96% 220 MB
|======================================================================================= | 96% 221 MB
|======================================================================================= | 96% 221 MB
|======================================================================================= | 96% 221 MB
|======================================================================================= | 96% 221 MB
|======================================================================================== | 96% 221 MB
|======================================================================================== | 96% 221 MB
|======================================================================================== | 96% 221 MB
|======================================================================================== | 96% 221 MB
|======================================================================================== | 96% 222 MB
|======================================================================================== | 96% 222 MB
|======================================================================================== | 97% 222 MB
|======================================================================================== | 97% 222 MB
|======================================================================================== | 97% 222 MB
|======================================================================================== | 97% 222 MB
|======================================================================================== | 97% 222 MB
|======================================================================================== | 97% 222 MB
|======================================================================================== | 97% 223 MB
|======================================================================================== | 97% 223 MB
|======================================================================================== | 97% 223 MB
|======================================================================================== | 97% 223 MB
|======================================================================================== | 97% 223 MB
|======================================================================================== | 97% 223 MB
|======================================================================================== | 97% 223 MB
|======================================================================================== | 97% 223 MB
|========================================================================================= | 97% 224 MB
|========================================================================================= | 97% 224 MB
|========================================================================================= | 97% 224 MB
|========================================================================================= | 97% 224 MB
|========================================================================================= | 98% 224 MB
|========================================================================================= | 98% 224 MB
|========================================================================================= | 98% 224 MB
|========================================================================================= | 98% 224 MB
|========================================================================================= | 98% 225 MB
|========================================================================================= | 98% 225 MB
|========================================================================================= | 98% 225 MB
|========================================================================================= | 98% 225 MB
|========================================================================================= | 98% 225 MB
|========================================================================================= | 98% 225 MB
|========================================================================================= | 98% 225 MB
|========================================================================================= | 98% 226 MB
|========================================================================================= | 98% 226 MB
|========================================================================================= | 98% 226 MB
|========================================================================================= | 98% 226 MB
|========================================================================================= | 98% 226 MB
|==========================================================================================| 98% 226 MB
|==========================================================================================| 98% 226 MB
|==========================================================================================| 99% 226 MB
|==========================================================================================| 99% 227 MB
|==========================================================================================| 99% 227 MB
|==========================================================================================| 99% 227 MB
|==========================================================================================| 99% 227 MB
|==========================================================================================| 99% 227 MB
|==========================================================================================| 99% 227 MB
|==========================================================================================| 99% 227 MB
|==========================================================================================| 99% 227 MB
|==========================================================================================| 99% 228 MB
|==========================================================================================| 99% 228 MB
|==========================================================================================| 99% 228 MB
|==========================================================================================| 99% 228 MB
|==========================================================================================| 99% 228 MB
|==========================================================================================| 99% 228 MB
|==========================================================================================| 99% 228 MB
|==========================================================================================| 99% 228 MB
|==========================================================================================| 99% 229 MB
|===========================================================================================| 100% 229 MB
crime_12062016_to_03192018 <-
read_csv("./data/DPD__All_Crime_Incidents__December_6__2016_-_3_19_2018.csv",
guess_max = 10^6)
Parsed with column specification:
cols(
.default = col_character(),
`Crime ID` = col_integer(),
`Day of Week (Sunday is 1)` = col_integer(),
`Hour of Day` = col_integer(),
Year = col_integer(),
`Census Block GEOID` = col_double(),
`Council District` = col_integer(),
`Zip Code` = col_integer(),
Longitude = col_double(),
Latitude = col_double(),
uniq = col_integer()
)
See spec(...) for full column specifications.
|= | 1%
|= | 1%
|== | 2%
|== | 2%
|== | 2%
|=== | 3% 1 MB
|=== | 3% 1 MB
|=== | 4% 1 MB
|==== | 4% 1 MB
|==== | 5% 1 MB
|==== | 5% 1 MB
|===== | 5% 1 MB
|===== | 6% 1 MB
|====== | 6% 2 MB
|====== | 7% 2 MB
|====== | 7% 2 MB
|======= | 7% 2 MB
|======= | 8% 2 MB
|======= | 8% 2 MB
|======== | 9% 2 MB
|======== | 9% 2 MB
|======== | 9% 3 MB
|========= | 10% 3 MB
|========= | 10% 3 MB
|========== | 11% 3 MB
|========== | 11% 3 MB
|========== | 11% 3 MB
|=========== | 12% 3 MB
|=========== | 12% 3 MB
|=========== | 13% 4 MB
|============ | 13% 4 MB
|============ | 13% 4 MB
|============= | 14% 4 MB
|============= | 14% 4 MB
|============= | 15% 4 MB
|============== | 15% 4 MB
|============== | 15% 4 MB
|============== | 16% 5 MB
|=============== | 16% 5 MB
|=============== | 17% 5 MB
|=============== | 17% 5 MB
|================ | 17% 5 MB
|================ | 18% 5 MB
|================= | 18% 5 MB
|================= | 19% 5 MB
|================= | 19% 6 MB
|================== | 19% 6 MB
|================== | 20% 6 MB
|================== | 20% 6 MB
|=================== | 21% 6 MB
|=================== | 21% 6 MB
|==================== | 22% 6 MB
|==================== | 22% 6 MB
|==================== | 22% 7 MB
|===================== | 23% 7 MB
|===================== | 23% 7 MB
|===================== | 24% 7 MB
|====================== | 24% 7 MB
|====================== | 24% 7 MB
|====================== | 25% 7 MB
|======================= | 25% 7 MB
|======================= | 26% 8 MB
|======================== | 26% 8 MB
|======================== | 26% 8 MB
|======================== | 27% 8 MB
|========================= | 27% 8 MB
|========================= | 28% 8 MB
|========================= | 28% 8 MB
|========================== | 28% 8 MB
|========================== | 29% 9 MB
|=========================== | 29% 9 MB
|=========================== | 30% 9 MB
|=========================== | 30% 9 MB
|============================ | 30% 9 MB
|============================ | 31% 9 MB
|============================ | 31% 9 MB
|============================= | 32% 9 MB
|============================= | 32% 10 MB
|============================== | 32% 10 MB
|============================== | 33% 10 MB
|============================== | 33% 10 MB
|=============================== | 34% 10 MB
|=============================== | 34% 10 MB
|=============================== | 35% 10 MB
|================================ | 35% 10 MB
|================================ | 35% 11 MB
|================================ | 36% 11 MB
|================================= | 36% 11 MB
|================================= | 37% 11 MB
|================================== | 37% 11 MB
|================================== | 37% 11 MB
|================================== | 38% 11 MB
|=================================== | 38% 11 MB
|=================================== | 39% 12 MB
|=================================== | 39% 12 MB
|==================================== | 39% 12 MB
|==================================== | 40% 12 MB
|===================================== | 40% 12 MB
|===================================== | 41% 12 MB
|===================================== | 41% 12 MB
|====================================== | 41% 12 MB
|====================================== | 42% 13 MB
|====================================== | 42% 13 MB
|======================================= | 43% 13 MB
|======================================= | 43% 13 MB
|======================================== | 43% 13 MB
|======================================== | 44% 13 MB
|======================================== | 44% 13 MB
|========================================= | 45% 13 MB
|========================================= | 45% 14 MB
|========================================= | 45% 14 MB
|========================================== | 46% 14 MB
|========================================== | 46% 14 MB
|========================================== | 47% 14 MB
|=========================================== | 47% 14 MB
|=========================================== | 48% 14 MB
|============================================ | 48% 14 MB
|============================================ | 48% 15 MB
|============================================ | 49% 15 MB
|============================================= | 49% 15 MB
|============================================= | 50% 15 MB
|============================================= | 50% 15 MB
|============================================== | 50% 15 MB
|============================================== | 51% 15 MB
|=============================================== | 51% 15 MB
|=============================================== | 52% 16 MB
|=============================================== | 52% 16 MB
|================================================ | 52% 16 MB
|================================================ | 53% 16 MB
|================================================ | 53% 16 MB
|================================================= | 54% 16 MB
|================================================= | 54% 16 MB
|================================================= | 54% 16 MB
|================================================== | 55% 17 MB
|================================================== | 55% 17 MB
|=================================================== | 56% 17 MB
|=================================================== | 56% 17 MB
|=================================================== | 56% 17 MB
|==================================================== | 57% 17 MB
|==================================================== | 57% 17 MB
|==================================================== | 58% 18 MB
|===================================================== | 58% 18 MB
|===================================================== | 59% 18 MB
|====================================================== | 59% 18 MB
|====================================================== | 59% 18 MB
|====================================================== | 60% 18 MB
|======================================================= | 60% 18 MB
|======================================================= | 61% 18 MB
|======================================================= | 61% 19 MB
|======================================================== | 61% 19 MB
|======================================================== | 62% 19 MB
|========================================================= | 62% 19 MB
|========================================================= | 63% 19 MB
|========================================================= | 63% 19 MB
|========================================================== | 63% 19 MB
|========================================================== | 64% 19 MB
|========================================================== | 64% 20 MB
|=========================================================== | 65% 20 MB
|=========================================================== | 65% 20 MB
|============================================================ | 65% 20 MB
|============================================================ | 66% 20 MB
|============================================================ | 66% 20 MB
|============================================================= | 67% 20 MB
|============================================================= | 67% 20 MB
|============================================================= | 67% 21 MB
|============================================================== | 68% 21 MB
|============================================================== | 68% 21 MB
|============================================================== | 69% 21 MB
|=============================================================== | 69% 21 MB
|=============================================================== | 70% 21 MB
|================================================================ | 70% 21 MB
|================================================================ | 70% 21 MB
|================================================================ | 71% 22 MB
|================================================================= | 71% 22 MB
|================================================================= | 72% 22 MB
|================================================================= | 72% 22 MB
|================================================================== | 72% 22 MB
|================================================================== | 73% 22 MB
|=================================================================== | 73% 22 MB
|=================================================================== | 74% 22 MB
|=================================================================== | 74% 23 MB
|==================================================================== | 74% 23 MB
|==================================================================== | 75% 23 MB
|==================================================================== | 75% 23 MB
|===================================================================== | 76% 23 MB
|===================================================================== | 76% 23 MB
|===================================================================== | 76% 23 MB
|====================================================================== | 77% 23 MB
|====================================================================== | 77% 24 MB
|======================================================================= | 78% 24 MB
|======================================================================= | 78% 24 MB
|======================================================================= | 78% 24 MB
|======================================================================== | 79% 24 MB
|======================================================================== | 79% 24 MB
|======================================================================== | 80% 24 MB
|========================================================================= | 80% 24 MB
|========================================================================= | 80% 25 MB
|========================================================================== | 81% 25 MB
|========================================================================== | 81% 25 MB
|========================================================================== | 82% 25 MB
|=========================================================================== | 82% 25 MB
|=========================================================================== | 83% 25 MB
|=========================================================================== | 83% 25 MB
|============================================================================ | 83% 25 MB
|============================================================================ | 84% 26 MB
|============================================================================= | 84% 26 MB
|============================================================================= | 85% 26 MB
|============================================================================= | 85% 26 MB
|============================================================================== | 85% 26 MB
|============================================================================== | 86% 26 MB
|============================================================================== | 86% 26 MB
|=============================================================================== | 87% 26 MB
|=============================================================================== | 87% 27 MB
|=============================================================================== | 87% 27 MB
|================================================================================ | 88% 27 MB
|================================================================================ | 88% 27 MB
|================================================================================= | 89% 27 MB
|================================================================================= | 89% 27 MB
|================================================================================= | 89% 27 MB
|================================================================================== | 90% 27 MB
|================================================================================== | 90% 28 MB
|================================================================================== | 91% 28 MB
|=================================================================================== | 91% 28 MB
|=================================================================================== | 91% 28 MB
|==================================================================================== | 92% 28 MB
|==================================================================================== | 92% 28 MB
|==================================================================================== | 93% 28 MB
|===================================================================================== | 93% 28 MB
|===================================================================================== | 94% 29 MB
|===================================================================================== | 94% 29 MB
|====================================================================================== | 94% 29 MB
|====================================================================================== | 95% 29 MB
|======================================================================================= | 95% 29 MB
|======================================================================================= | 96% 29 MB
|======================================================================================= | 96% 29 MB
|======================================================================================== | 96% 29 MB
|======================================================================================== | 97% 30 MB
|======================================================================================== | 97% 30 MB
|========================================================================================= | 98% 30 MB
|========================================================================================= | 98% 30 MB
|==========================================================================================| 98% 30 MB
|==========================================================================================| 99% 30 MB
|==========================================================================================| 99% 30 MB
|===========================================================================================| 100% 30 MB
#the 311 system
improve_detroit_issues <- read_csv("./data/Improve_Detroit_Issues_3_19_2018.csv",
guess_max = 10^6)
Parsed with column specification:
cols(
`Ticket ID` = col_integer(),
`Ticket Status` = col_character(),
`Issue Type` = col_character(),
`Issue Description` = col_character(),
`Created At` = col_character(),
`Acknowledged At` = col_character(),
`Closed At` = col_character(),
`Reopened At` = col_character(),
`Updated At` = col_character(),
`Days to Close` = col_double(),
`Report Method` = col_character(),
`Priority Code` = col_integer(),
`Canonical Issue Id` = col_integer(),
`Web Link` = col_character(),
Address = col_character(),
Neighborhood = col_character(),
`Council District` = col_integer(),
Location = col_character()
)
|========== | 11% 4 MB
|=========== | 12% 4 MB
|=========== | 12% 4 MB
|============ | 13% 5 MB
|============ | 13% 5 MB
|============ | 14% 5 MB
|============= | 14% 5 MB
|============= | 15% 5 MB
|============== | 15% 5 MB
|============== | 16% 6 MB
|=============== | 16% 6 MB
|=============== | 17% 6 MB
|=============== | 17% 6 MB
|================ | 17% 6 MB
|================ | 18% 7 MB
|================= | 18% 7 MB
|================= | 19% 7 MB
|================== | 19% 7 MB
|================== | 20% 7 MB
|================== | 20% 7 MB
|=================== | 21% 8 MB
|=================== | 21% 8 MB
|==================== | 22% 8 MB
|==================== | 22% 8 MB
|===================== | 23% 8 MB
|===================== | 23% 8 MB
|===================== | 24% 9 MB
|====================== | 24% 9 MB
|====================== | 25% 9 MB
|======================= | 25% 9 MB
|======================= | 25% 9 MB
|======================== | 26% 10 MB
|======================== | 26% 10 MB
|======================== | 27% 10 MB
|========================= | 27% 10 MB
|========================= | 28% 10 MB
|========================== | 28% 10 MB
|========================== | 29% 11 MB
|=========================== | 29% 11 MB
|=========================== | 30% 11 MB
|=========================== | 30% 11 MB
|============================ | 31% 11 MB
|============================ | 31% 12 MB
|============================= | 32% 12 MB
|============================= | 32% 12 MB
|============================== | 33% 12 MB
|============================== | 33% 12 MB
|============================== | 33% 12 MB
|=============================== | 34% 13 MB
|=============================== | 34% 13 MB
|================================ | 35% 13 MB
|================================ | 35% 13 MB
|================================= | 36% 13 MB
|================================= | 36% 14 MB
|================================= | 37% 14 MB
|================================== | 37% 14 MB
|================================== | 38% 14 MB
|=================================== | 38% 14 MB
|=================================== | 39% 14 MB
|==================================== | 39% 15 MB
|==================================== | 40% 15 MB
|==================================== | 40% 15 MB
|===================================== | 41% 15 MB
|===================================== | 41% 15 MB
|====================================== | 41% 15 MB
|====================================== | 42% 16 MB
|======================================= | 42% 16 MB
|======================================= | 43% 16 MB
|======================================= | 43% 16 MB
|======================================== | 44% 16 MB
|======================================== | 44% 17 MB
|========================================= | 45% 17 MB
|========================================= | 45% 17 MB
|========================================= | 46% 17 MB
|========================================== | 46% 17 MB
|========================================== | 47% 17 MB
|=========================================== | 47% 18 MB
|=========================================== | 48% 18 MB
|============================================ | 48% 18 MB
|============================================ | 49% 18 MB
|============================================= | 49% 18 MB
|============================================= | 49% 19 MB
|============================================= | 50% 19 MB
|============================================== | 50% 19 MB
|============================================== | 51% 19 MB
|=============================================== | 51% 19 MB
|=============================================== | 52% 19 MB
|================================================ | 52% 20 MB
|================================================ | 53% 20 MB
|================================================ | 53% 20 MB
|================================================= | 54% 20 MB
|================================================= | 54% 20 MB
|================================================== | 55% 21 MB
|================================================== | 55% 21 MB
|=================================================== | 56% 21 MB
|=================================================== | 56% 21 MB
|=================================================== | 57% 21 MB
|==================================================== | 57% 21 MB
|==================================================== | 58% 22 MB
|===================================================== | 58% 22 MB
|===================================================== | 59% 22 MB
|====================================================== | 59% 22 MB
|====================================================== | 59% 22 MB
|====================================================== | 60% 22 MB
|======================================================= | 60% 23 MB
|======================================================= | 61% 23 MB
|======================================================== | 61% 23 MB
|======================================================== | 62% 23 MB
|========================================================= | 62% 23 MB
|========================================================= | 63% 24 MB
|========================================================== | 63% 24 MB
|========================================================== | 64% 24 MB
|========================================================== | 64% 24 MB
|=========================================================== | 65% 24 MB
|=========================================================== | 65% 24 MB
|============================================================ | 66% 25 MB
|============================================================ | 66% 25 MB
|============================================================= | 67% 25 MB
|============================================================= | 67% 25 MB
|============================================================= | 68% 25 MB
|============================================================== | 68% 26 MB
|============================================================== | 69% 26 MB
|=============================================================== | 69% 26 MB
|=============================================================== | 69% 26 MB
|================================================================ | 70% 26 MB
|================================================================ | 70% 27 MB
|================================================================= | 71% 27 MB
|================================================================= | 71% 27 MB
|================================================================= | 72% 27 MB
|================================================================== | 72% 27 MB
|================================================================== | 73% 27 MB
|=================================================================== | 73% 28 MB
|=================================================================== | 74% 28 MB
|=================================================================== | 74% 28 MB
|==================================================================== | 75% 28 MB
|==================================================================== | 75% 28 MB
|===================================================================== | 76% 28 MB
|===================================================================== | 76% 29 MB
|====================================================================== | 76% 29 MB
|====================================================================== | 77% 29 MB
|====================================================================== | 77% 29 MB
|======================================================================= | 78% 29 MB
|======================================================================= | 78% 29 MB
|======================================================================== | 79% 30 MB
|======================================================================== | 79% 30 MB
|======================================================================== | 80% 30 MB
|========================================================================= | 80% 30 MB
|========================================================================= | 81% 30 MB
|========================================================================== | 81% 31 MB
|========================================================================== | 81% 31 MB
|========================================================================== | 82% 31 MB
|=========================================================================== | 82% 31 MB
|=========================================================================== | 83% 31 MB
|============================================================================ | 83% 31 MB
|============================================================================ | 84% 32 MB
|============================================================================= | 84% 32 MB
|============================================================================= | 85% 32 MB
|============================================================================= | 85% 32 MB
|============================================================================== | 86% 32 MB
|============================================================================== | 86% 32 MB
|=============================================================================== | 86% 33 MB
|=============================================================================== | 87% 33 MB
|=============================================================================== | 87% 33 MB
|================================================================================ | 88% 33 MB
|================================================================================ | 88% 33 MB
|================================================================================= | 89% 33 MB
|================================================================================= | 89% 34 MB
|================================================================================== | 90% 34 MB
|================================================================================== | 90% 34 MB
|================================================================================== | 91% 34 MB
|=================================================================================== | 91% 34 MB
|=================================================================================== | 92% 35 MB
|==================================================================================== | 92% 35 MB
|==================================================================================== | 93% 35 MB
|===================================================================================== | 93% 35 MB
|===================================================================================== | 93% 35 MB
|===================================================================================== | 94% 35 MB
|====================================================================================== | 94% 36 MB
|====================================================================================== | 95% 36 MB
|======================================================================================= | 95% 36 MB
|======================================================================================= | 96% 36 MB
|======================================================================================== | 96% 36 MB
|======================================================================================== | 97% 37 MB
|======================================================================================== | 97% 37 MB
|========================================================================================= | 98% 37 MB
|========================================================================================= | 98% 37 MB
|==========================================================================================| 99% 37 MB
|==========================================================================================| 99% 37 MB
|===========================================================================================| 100% 38 MB
#the shapefile representing Detroit parcels, read into
parcel_sf <- st_read("./data/Parcel Map")
Reading layer `geo_export_ad366f11-96e5-4f0f-9d17-7a6ae8e48482' from data source `/Users/stuartbarnum/Desktop/R files/Detroit-Demolitions/data/Parcel Map' using driver `ESRI Shapefile'
Simple feature collection with 382051 features and 37 fields
geometry type: MULTIPOLYGON
dimension: XY
bbox: xmin: -83.28763 ymin: 42.25539 xmax: -82.91066 ymax: 42.45011
epsg (SRID): 4326
proj4string: +proj=longlat +ellps=WGS84 +no_defs
#writeLines(c("parcel_sf", " ", colnames(parcel_sf)), "parcel_sf.txt")
For all of the downloaded datasets other than the parcels dataset, we extract extract the usable latutude and longitude values and then use this information to form simple features (sf) objects. Rows with bviously incorrect values, or values that would represent positions well outside Detroit, are filtered out, together with rows for which the latitude or longitude data is missing.
#function for converting the position (character) column into a column of points in the simple features (sf) framework.
add_sf_point <- function(df, column) {
#extract the latitude and longitude from the string column that contains both. With the parentheses
#located from the end of the strings, it is possible to use the the same function for all five of
#the datasets for which we need to extract this information.
latitude <- str_sub(df[[column]],
stringi::stri_locate_last_fixed(df[[column]], "(")[,2] + 1,
stringi::stri_locate_last_fixed(df[[column]], ",")[,1] - 1)
longitude <- str_sub(df[[column]],
stringi::stri_locate_last_fixed(df[[column]], ", ")[,2] + 1,
stringi::stri_locate_last_fixed(df[[column]], ")")[,1] - 1)
#add the latititude and and longitude to a copy of the dataframe, filter out the NAs from
#these results, and then convert convert to sf, with point positions indicated in the
#geometry column
mutated <- df %>% mutate(extracted_lat = as.double(latitude),
extracted_lon = as.double(longitude))
#remove rows with NAs for latitude or longitude, or with values well outside of Detroit
filtered <- mutated %>%
filter(!is.na(extracted_lat) & !is.na(extracted_lon)) %>%
filter(41 < extracted_lat & extracted_lat < 44 & -85 < extracted_lon & extracted_lon < -81)
#create a dataframe from the items that have been filtered out
result_coord_na <- setdiff(mutated, filtered)
#create sf objects from the rows with usable latitude and longitude information
result_sf <- st_as_sf(filtered, coords = c("extracted_lon", "extracted_lat"), crs = 4326)
return(list(result_sf, result_coord_na))
}
#apply the function to the five datasets for which the data was not loaded as a simple features dataframe, thus producing a list of two dataframes for each of the datasets, the first element of the list a simple features data frame and the second element a dataframe with the instances for which it was not possible to convert to simple features
blight_violations_split <- add_sf_point(blight_violations, "Violation Location")
dismantle_permits_split <- add_sf_point(dismantle_permits, "Permit Location")
crime_to_12062016_split <- add_sf_point(crime_to_12062016, "LOCATION")
crime_12062016_to_03192018_split <- add_sf_point(crime_12062016_to_03192018, "Location")
improve_detroit_issues_split <- add_sf_point(improve_detroit_issues, "Location")
We now consider the data for which we do not yet have position data, and complete the information as well as we reasonably can, using the Google api and a function, geocode_pause, that handles some of api’s quirks.
#the portino of the downloaded blight citations data, for which we do not have
blight_vio_na <- blight_violations_split[[2]]
#remove the rows for which geocoding is not likely to prodoce reliable results
useful <- blight_vio_na %>% filter(!is.na(`Violation Street Name`),
`Violation Street Number` > 0,
!is.na(`Violation Zip Code`))
#create a column of addresses to be used in geocoding
useful <- useful %>%
mutate(complete_address = paste(`Violation Street Number`, " ", `Violation Street Name`, ", ",
"Detroit, Michigan", " ", `Violation Zip Code`, sep = ""))
#function makes a maximum 6 attempts to geocode the given address using the Google API, with a pause of 1 second between attempts. We will use the function for the other datasets as well.
geocode_pause <- function(address) {
for (index in 1:6) {
Sys.sleep(1)
location <- ggmap::geocode(address)
if (!is.na(location$lon)) {
return(location)
}
}
}
#apply geocode_pause to each of the elements of the complete_addresse column and place the result in a new column, in which each entry is a data frame
useful <- useful %>% mutate(location = map(complete_address, geocode_pause))
#save to disc, to avoid avoid the need to geocode these addresses again when we rerun the analysis
write_rds(useful, "./data/blight_violations_geocodes.rds")
The geocoding has returned a data frame for each of the addresses. We thus need to unpack the elements of the location column, each of which is a data frame.
#read blight_violations_geocodes as a tibble
blight_violations_geocodes <- read_rds("./data/blight_violations_geocodes.rds")
#function for removing the instances for which geocoding failed (for which the value in the location column is NULLL). We will use this function for all of the geocoded data frames.
remove_null_locations <- function(df) {
#identify the rows for which the value in the location column is NULL
null_rows <- list()
for (index in 1:nrow(df)) {
if (is.null(df$location[[index]])) {
null_rows <- c(null_rows, index)
}
}
#remove the rows for which the value of the location column is NULL
df <- df[-as.integer(null_rows),]
}
blight_violations_geocodes <- remove_null_locations(blight_violations_geocodes)
#With blight_violations_geocodes a tibble, we can apply tidyr::unnest(), which will place the latitude and longitude in columns labelled "lat" and "lon".
blight_violations_geocodes <- blight_violations_geocodes %>% unnest(location)
#fill in the `Violation Latitute` and `Violation Longitude` data frames, which alread exist in the blight_violations data frame
blight_violations_geocodes <- blight_violations_geocodes %>%
mutate(`Violation Latitude` = lat,
`Violation Longitude` = lon)
#cut out some columns that have been added
blight_violations_geocodes <- blight_violations_geocodes %>%
select(-extracted_lat, -extracted_lon, -complete_address)
#put the position information into a simple features format (which will remove the "lat" and "lon" columns)
blight_violations_geocodes_sf <- st_as_sf(blight_violations_geocodes,
coords = c("lon", "lat"),
crs = 4326)
#combine the results with the previously generated sf data
blight_violations_sf <- rbind(blight_violations_split[[1]], blight_violations_geocodes_sf)
rm(blight_vio_na, blight_violations, blight_violations_geocodes,
blight_violations_geocodes_sf, blight_violations_split, useful)
#the dismantle permits for which position data (latitude and longitude) is missing
dismantle_permits_split_na <- dismantle_permits_split[[2]]
#remove the last two columns, which were not contained in the original dismantle_permits datastet
dismantle_permits_split_na <- dismantle_permits_split_na %>%
select(-extracted_lat, -extracted_lon)
#geocode the items in dismantle_permits_split_na, using the address column and the function geocode_pause, which makes a maximum of six attempts for each item. The result is list of dataframes in the location column.
dismantle_permits_split_geocode <- dismantle_permits_split_na %>%
mutate(location = map(str_c(`Site Address`, ", Detroit, Michigan"), geocode_pause))
#write the results of the geocoding to disk, to avoid having to repeat the geocoding when rerunning the analysis.
write_rds(dismantle_permits_split_geocode, "./data/dismantle_permits_geocodes.rds")
rm(dismantle_permits_split_na)
#load the geocoded data frame into R
dismantle_permits_split_geocode <- read_rds("./data/dismantle_permits_geocodes.rds")
#use the remove_null_locations() to remove the rows for which geocoding failed and then parse the information in the dataframes in the location column into two new columns, lat and lan
dismantle_permits_split_geocode <-
remove_null_locations(dismantle_permits_split_geocode) %>%
unnest(location)
#convert to a simple features (sf) data frame, using the latititudes and longitudes
dismantle_permits_geocode_sf <- st_as_sf(dismantle_permits_split_geocode,
coords = c("lon", "lat"),
crs = 4326)
#append this simple features dataframe to the dataframe for which we already had usable positions
dismantle_permits_sf <- rbind(dismantle_permits_split[[1]], dismantle_permits_geocode_sf)
rm(dismantle_permits_split_geocode, dismantle_permits_geocode_sf, dismantle_permits, dismantle_permits_split, dismantle_permits_split_na)
We now fill-in the missing position information for the dataset for crimes up to 12-06-2016
#return to the older crime data
crime_to_12062016_leftovers <- crime_to_12062016_split[[2]]
#cut out the addresses that begin with "00"
crime_to_12062016_leftovers <- crime_to_12062016_leftovers %>%
filter(str_sub(LOCATION, 1, 2) != "00")
#filter out some obviously useless addresses, with few characters before the first "("
crime_to_12062016_leftovers <- crime_to_12062016_leftovers %>%
filter(!str_locate(LOCATION, "\\(")[,1] %in% 1:13)
#remove the two columns that were added earlier
crime_to_12062016_leftovers <- crime_to_12062016_leftovers %>%
select(-extracted_lat, -extracted_lon)
#create a column for use in geocoding
crime_to_12062016_leftovers <- crime_to_12062016_leftovers %>%
mutate(extracted_address = str_c(str_sub(LOCATION, 1,
str_locate(LOCATION, "\\(")[,1] - 2),
", Detroit, Michigan"))
#geocode the elements of extracted_address, using the function geocode_pause
crime_to_12062016_leftovers_geocode <- crime_to_12062016_leftovers %>%
mutate(location = map(extracted_address, geocode_pause))
#save the results, to avoid having to geocode again when rerunning the analysis
write_rds(crime_to_12062016_leftovers_geocode, "./data/crime_to_12062016_leftovers_geocode.rds")
crime_to_12062016_leftovers_geocode <- read_rds("./data/crime_to_12062016_leftovers_geocode.rds")
#cut out the column we used for geocoding
crime_to_12062016_leftovers_geocode <-
crime_to_12062016_leftovers_geocode %>% select(-extracted_address)
#cut out of the geocode failures and put the location information into the columns lat and lon
crime_to_12062016_leftovers_geocode <-
remove_null_locations(crime_to_12062016_leftovers_geocode) %>%
unnest(location)
#create a simple features (sf) object, using the latititudes and longitudes
crime_to_12062016_leftovers_sf <- st_as_sf(crime_to_12062016_leftovers_geocode,
coords = c("lon", "lat"),
crs = 4326)
#append this simple features dataframe to the dataframe for which we already had locations
crime_to_12062016_sf <- rbind(crime_to_12062016_split[[1]], crime_to_12062016_leftovers_sf)
rm(crime_to_12062016, crime_to_12062016_leftovers_geocode, crime_to_12062016_leftovers_sf, crime_to_12062016_leftovers, crime_to_12062016_split)
#consider the examples in the recent crime data for which the conversion to sf didn't work, remove the two columns that we have added, and create and address column for geocoding
crime_12062016_to_03192018_leftovers <- crime_12062016_to_03192018_split[[2]] %>%
select(-extracted_lat, -extracted_lon) %>%
mutate(extracted_address = str_c(`Incident Address`, ", Detroit, Michigan"))
crime_12062016_to_03192018_geocode <- crime_12062016_to_03192018_leftovers %>%
mutate(location = map(extracted_address, geocode_pause))
write_rds(crime_12062016_to_03192018_geocode, "./data/crime_12062016_to_03192018_geocode.rds")
crime_12062016_to_03192018_geocode <- read_rds("./data/crime_12062016_to_03192018_geocode.rds") %>%
select(-extracted_address)
#remove the rows for which the value of location is NULL and then unnest the remaining locations
crime_12062016_to_03192018_geocode <-
remove_null_locations(crime_12062016_to_03192018_geocode) %>%
unnest(location)
#convert the dataframe to a simple features set
crime_12062016_to_03192018_sf <- st_as_sf(crime_12062016_to_03192018_geocode,
coords = c("lon", "lat"),
crs = 4326)
#combine the geocoded data with the sf dataframe created earlier
crime_12062016_to_03192018 <- rbind(crime_12062016_to_03192018_split[[1]], crime_12062016_to_03192018_sf)
rm(crime_12062016_to_03192018_split, crime_12062016_to_03192018_geocode, crime_12062016_to_03192018_leftovers, crime_12062016_to_03192018_sf)
#geocode the one item in the Improve Detroit Issues data for which the given coordinates were obviously incorrect, and then convert to an sf object. If geocoding fails, run this bit again
improve_detroit_issues_leftover_sf <- improve_detroit_issues_split[[2]] %>%
select(-extracted_lat, -extracted_lon) %>%
mutate(location = map(Address, geocode_pause)) %>%
unnest(location) %>%
st_as_sf(coords = c("lon", "lat"), crs = 4326)
Error in eval(lhs, parent, parent) :
object 'improve_detroit_issues_split' not found
We begin the assignment of labels to the buidings: blighted or not blighted. Buildings will be represented by parcels that have or have had buildings on them, whether by being so represented as in the parcels_sf data frame as including structures or in the dismantle permits dataframe as having had a dismante permit associated with it, thus suggesting that there was a building on the parcel.
We will use parcel numbers to refer to the parcels. This works because parcelnum column contains no repeats over different rows (see below, in which duplicate_parcel_numbers_in_parcel_data has zero rows).
#As per above, following returns an empty data frame
duplicate_parcel_numbers_in_parcel_data <-
parcel_sf %>%
group_by(parcelnum) %>%
mutate(n = n()) %>%
ungroup() %>%
filter(n > 1)
duplicate_parcel_numbers_in_parcel_data
Simple feature collection with 78 features and 38 fields
geometry type: MULTIPOLYGON
dimension: XY
bbox: xmin: -83.17034 ymin: 42.32219 xmax: -83.0055 ymax: 42.4416
epsg (SRID): 4326
proj4string: +proj=longlat +ellps=WGS84 +no_defs